Howard Lowndes <[EMAIL PROTECTED]> writes: > On Wed, 1 Oct 2003, Tom Lane wrote: >> No, because pg_restore has logic to adjust the references to match the >> new BLOB OIDs. If you have a test case where this fails to work, let's >> see it ...
> No, I don't have any example, it is an enquiry. What I am reading into > the above however is that the loid column in my table should have a > CONSTRAINT REFERENCES clause to whereever in the system large objects > table. Correct? No. No doubt if Postgres had had foreign keys when the large-object stuff was invented, it would have required such a constraint for LO references, but it didn't and it doesn't. The pg_restore code simply goes through all "oid" columns (and all "lo" columns if you've installed the contrib/lo datatype) and looks for matches to LO OIDs that existed in the dumped database. When it finds a match, it replaces that value with the new BLOB's OID. Simple, effective, crufty ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly