Re: Killing OIDs

On Wed, Feb 11, 2009 at 12:59 PM, Steve Crawford
<scrawford@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.