Il giorno sab, 29/01/2011 alle 17.36 +0100, Philipp Kern ha scritto: [...] > Did you import pg_catalog? Because that's where your blobs are stored. > If you unselect this, the export and subsequent import will succeed due > to the OIDs being valid and due to a missing foreign key relationship > when used with large objects. However they will be dangling.
I imported only one schema using pg_restore with option --schema. >I thus don't agree that this is utterly broken. PostgreSQL could do >better with a check for large objects, and presenting a warning if >pg_catalog isn't selected, but as a DBA I guess you need to know that >fact if you handle large objects. well, no, I still think it is an important bug, since not everyone working with postgresql need to know how it works internally. Bye, Giuseppe -- To UNSUBSCRIBE, email to [email protected] with a subject of "unsubscribe". Trouble? Contact [email protected]
