Re: OIDs depending data -- how to dump/restore?

On Sunday 14 March 2010 9:21:06 am fkater(at)googlemail(dot)com wrote:
> Hi all,
>
> I have several databases here which I would like to update
> from 8.2 to 8.4, which in turn requires a dump/restore.
>
> However, the databases are OIDs depending, so, some values
> depend on OIDs in other tables.
>
> AFAIK the dump/restore does not rebuild the original OID
> values, so all relations built accross OIDs fail.
>
> (1)
> Is there a way to keep the original OID values somehow?

From here:
http://www.postgresql.org/docs/8.4/interactive/app-pgdump.html

-o
--oids

Dump object identifiers (OIDs) as part of the data for every table. Use this
option if your application references the OID columns in some way (e.g., in a
foreign key constraint). Otherwise, this option should not be used.

>
> (2)
> If I need to go the long way and replace the OIDs with
> SERIALs first, updating all relations to it etc: Would a
> dump/restore then restore the original values in a SERIAL
> column?
>
> Thank You
> Felix

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com