Alvaro Herrera <alvherre@commandprompt.com> writes:
> fkater@googlemail.com wrote:
>> 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.
+1
> 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.
I think you'd probably be able to get away with it, because pg_dump
always creates all tables before loading any data. If you were storing
index OIDs, maybe it wouldn't work.
regards, tom lane