On Sat, Jan 29, 2011 at 06:49:27PM +0100, Giuseppe Sacco wrote: > 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.
Meh, so it wasn't the package's doing? > >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. True. But it's not a bug in the package if your manual data conversion goes wrong. Kind regards Philipp Kern
signature.asc
Description: Digital signature
