| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
| Cc: | rod(at)iol(dot)ie, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Killing OIDs |
| Date: | 2009-02-11 20:36:45 |
| Message-ID: | dcc563d10902111236u7ed7a079m4ae845430eb3fdbe@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Feb 11, 2009 at 12:59 PM, Steve Crawford
<scrawford(at)pinpointresearch(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2009-02-11 21:44:47 | Re: Two-phase commmit, plpgsql and plproxy |
| Previous Message | Steve Crawford | 2009-02-11 20:18:10 | Re: Killing OIDs |