Re: Killing OIDs

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