backup tableoids (pg_class.oid) ? - Mailing list pgsql-general

From fkater@googlemail.com
Subject backup tableoids (pg_class.oid) ?
Date
Msg-id 20080204151412.GA32749@comppasch2
Whole thread Raw
Responses Re: backup tableoids (pg_class.oid) ?
Re: backup tableoids (pg_class.oid) ?
List pgsql-general
Hi,

my db structure relays on the OIDs of tables (stored as OIDs of
pg_class).

However, 'pg_dumpall -o ...' seems to save the oids of all data but not
the tableoids, so, when I restore data I get different tableoids than I
had before!

Is there anything I could do to backup and restore even the tableoids
(besides stopping server and copying the files) ?

Thank you

Felix



pgsql-general by date:

Previous
From: Gregory Stark
Date:
Subject: Re: [pgsql-advocacy] PostgreSQL Certification
Next
From: "Pau Marc Munoz Torres"
Date:
Subject: loading files into tables