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

From Alvaro Herrera
Subject Re: backup tableoids (pg_class.oid) ?
Date
Msg-id 20080204172319.GB16380@alvh.no-ip.org
Whole thread Raw
In response to backup tableoids (pg_class.oid) ?  ("fkater@googlemail.com" <fkater@googlemail.com>)
Responses Re: backup tableoids (pg_class.oid) ?
List pgsql-general
fkater@googlemail.com wrote:
> Hi,
>
> my db structure relays on the OIDs of tables (stored as OIDs of
> pg_class).

Probably it would be a better idea to store that as type regclass
instead of OIDs.  I think that will take care of the dump part of the
problem, at least.  It's likely that there will be an additional hurdle
when trying to restore, because the referenced table would not have been
created in the first place.

That said, IMHO the idea of storing metadata as part of data is a bad
idea.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Josh Berkus
Date:
Subject: Re: [pgsql-advocacy] PostgreSQL Certification
Next
From: Alvaro Herrera
Date:
Subject: Re: PGSQL ERROR: FATAL: terminating connection due to administrator command