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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-hackers pgsql-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

Browse pgadmin-support by date

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

Browse pgsql-hackers by date

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

Browse pgsql-odbc by date

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