Hello list,
I've got a problem. I have a table like this:
id | integer | not null item_table_oid | oid | item_row_id | oid |
"id" is a serial field for this table,
"item_table_oid" is an oid referencing the oid of the table in the pg_catalog.pg_class table
"item_row_id" is an oid that references the oid of a data row in the table refered by item_table_oid
When I pg_dumpall -o and then I try to restore it in a clean cluster every table has new OIDs so the item_table_oid is invalid.
I did a "DELETE FROM pg_class" and I learnt that it's a quick way of erasing a database.
Isn't there any way of dumping the pg_class entries so the references would still work after restoring in a clean env?
Thanks in advance,
-- Juan Alonso http://gamersmafia.com | http://laflecha.net
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
