On Wed, Feb 11, 2009 at 12:59 PM, Steve Crawford <scrawf...@pinpointresearch.com> wrote: > Raymond O'Donnell wrote: >> >> >>> >>> Since 8.3 creates tables WITHOUT OIDS by default, I'd think just >>> dumping from 7.4 to 8.3 with 8.3's pg_dump should do the trick. Or am >>> I missing something? >>> >> >> I could be wrong, but I think 8.3's pg_dump will append WITH (OIDS=TRUE) >> if it finds tables with OIDs. > > 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
