severity 611352 normal On Fri, Jan 28, 2011 at 01:20:59PM +0100, Giuseppe Sacco wrote: > For one of these databases, I select to only import only one schema > instead of importing the whole database. > > The schema include a tables with blobs, i.e., a field of type OID > referring to a blob.
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 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. Kind regards and thanks for the bug report Philipp Kern
signature.asc
Description: Digital signature
