Scott Marlowe wrote:
Close. It actually does a "SET default_with_oids = true;" (or false) prior
to the CREATE TABLE statement. In any case, it does preserve the OID setting
of the source database.
So, I'd think it would be easier to just edit the backup than to muck
around in the 7.4 database.
The query to generate the drop-OID script runs in a fraction of a second
and the drop-OID script itself takes a second or two and I'm done. The
alternative requires running many gigs through sed (multiple times since
I have to run preliminary tests).
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
