Re: Killing OIDs - Mailing list pgsql-general

From Steve Crawford
Subject Re: Killing OIDs
Date
Msg-id 49933282.4040408@pinpointresearch.com
Whole thread Raw
In response to Re: Killing OIDs  ("Daniel Verite" <daniel@manitou-mail.org>)
List pgsql-general
Daniel Verite wrote:
> I seems to me that pg_dump does it for you anyway, unless you ask
> otherwise. See the -o option.
>
>
No, as I understand it this does not influence whether or not the table
is recreated with OIDs, it determines whether the _values_ of the OIDs
are included in the dumped data. Without this option, new OIDs are
created on restore - not good if you expect them to remain unchanged
(foreign key or whatever).

Cheers,
Steve


pgsql-general by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: Killing OIDs
Next
From: Alvaro Herrera
Date:
Subject: PostgreSQL "freebsd ports" package description outdated