Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> writes:
> fkater@xxxxxxxxxxxxxx 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
