Skip site navigation (1) Skip section navigation (2)

pgAdmin users upgrading to PostgreSQL 7.2

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org>, "'pgadmin-hackers(at)greatbridge(dot)org'" <pgadmin-hackers(at)greatbridge(dot)org>
Cc: pgsql-odbc(at)postgresql(dot)org, pgadmin-support(at)postgresql(dot)org
Subject: pgAdmin users upgrading to PostgreSQL 7.2
Date: 2001-10-02 07:45:19
Message-ID: AA30E7BCCA5C1D4E88A231900F8325C00B52@dogbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-supportpgsql-hackerspgsql-odbc
Hi,

It's come to my attention that users of pgAdmin (the original, not pgAdmin
II) will not be able to dump/reload their 7.1.x databases into 7.2 without
an additional step in the upgrade procedure.

This is because pgAdmin creates a number of views on the server which
include the oid column from tables such as pg_attribute - obviously
attempting to reload these view will cause an error as there is no longer an
oid column in pg_attribute in 7.2.

pgAdmin II is unaffected by this problem.

I will obviously try to assist anyone who suffers from this problem, but if
the following text can be added to the INSTALL file and anywhere else that
may be appropriate it might help ease the pain!

{at the end of #2 under 'If you are upgrading)

     pgAdmin 7.x users will need to drop server side objects before dumping 
     their database, otherwise the reload will fail. To do this, select
     'Drop all pgAdmin Server Side Objects' from the 'Advanced' menu.
     pgAdmin does not support PostgreSQL 7.2, instead, please try pgAdmin II
     from http://pgadmin.postgresql.org/.


Regards, Dave.

-- 
Dave Page (dpage(at)postgresql(dot)org)
pgAdmin Project Leader
http://pgadmin.postgresql.org/ 

Responses

pgsql-hackers by date

Next:From: Hannu KrosingDate: 2001-10-02 07:49:03
Subject: But _where_ is the anoncvs server ?
Previous:From: Tatsuo IshiiDate: 2001-10-02 06:49:52
Subject: Re: Unicode combining characters

pgsql-odbc by date

Next:From: Ryan C. BonhamDate: 2001-10-02 15:38:07
Subject: Move Previous
Previous:From: Dave PageDate: 2001-10-02 07:28:09
Subject: Re: [ODBC] New driver options in 7.01.0007

pgadmin-support by date

Next:From: Colin FreasDate: 2001-10-04 19:04:29
Subject: Editing tables
Previous:From: Dave PageDate: 2001-09-29 10:15:45
Subject: Re: Failed to load control "HBX"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group