Re: Killing OIDs - Mailing list pgsql-general

From Steve Crawford
Subject Re: Killing OIDs
Date
Msg-id 49945614.3070803@pinpointresearch.com
Whole thread Raw
In response to Re: Killing OIDs  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: Killing OIDs  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Rory Campbell-Lange
Date:
Subject: Re: row constructors
Next
From: Merlin Moncure
Date:
Subject: Re: row constructors