Dave,
Thanks for replying, but I get the error regardless of whether I use pg_dump's -o switch or not (I just tried it).
Also, Roberto's migration instructions specifically indicate the -o switch.
I have been using his instructions, so I know about the views. His instructions have some gaps in them; they are definitely more for experts than not, so I am wondering if I am missing something.
(This may be neither here nor there, but if I dump with -o and then import back into PG 7.1, I do not get the oid problem.)
I am being careful about using 7.1 or 7.2 binaries and environment variables as appropriate.
-Kevin
P.S. Here's a script showing me redoing the whole procedure NOT using the -o switch:
Script started on Wed Jan 22 14:10:03 2003
nsadmin@linux:/web/med_dev> pg_dump -V
pg_dump (PostgreSQL) 7.1.3
Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group
Portions Copyright (c) 1996 Regents of the University of California
Read the file COPYRIGHT to see the usage and distribution terms.
nsadmin@linux:/web/med_dev> pg_dump media >media-7.1.dmp
nsadmin@linux:/web/med_dev> . ~/pg723.sh
nsadmin@linux:/web/med_dev> which dropdb
/usr/local/pgsql-7.2.3/bin/dropdb
nsadmin@linux:/web/med_dev> dropdb med_dev
DROP DATABASE
nsadmin@linux:/web/med_dev> createdb -T template0 med_dev
CREATE DATABASE
nsadmin@linux:/web/med_dev> createdlang plpgsql med_dev
nsadmin@linux:/web/med_dev> psql -f postgresql-7.1.sql med_dev
(a bunch of CREATE's, etc, -- no errors)
nsadmin@linux:/web/med_dev> psql -f media-7.1.dmp med_dev 2>errors-no-o.log >/dev/null
nsadmin@linux:/web/med_dev> grep ERROR errors-no-o.log | grep -v "already exists"
psql:media-7.1.dmp:740: ERROR: No such attribute or function 'oid'
psql:media-7.1.dmp:4678: ERROR: parser: parse error at or near "SELECT"
psql:media-7.1.dmp:4686: ERROR: parser: parse error at or near "SELECT"
psql:media-7.1.dmp:21324: ERROR: Relation "party_approved_member_map" does not exist
