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/