my column types are and have always been oid, but for some weird reason when I dump and restore, I can't seem to reference my blobs anymore. I have done this a zillion times, and just can't figure our what the heck I'm doing wrong (this time).
On Mon, 2004-01-26 at 14:03, Tom Lane wrote: > Jeremiah Jahn <[EMAIL PROTECTED]> writes: > > when I run the following two commands all of my OIDs for my blobs (about > > 5.5 million of them) no longer reference anything in pg_largeobject. > > All of the loid values change. > > pg_dump/pg_restore do not (and cannot) arrange for large objects to have > the same OIDs after restore as they had before. What they do try to do > is update references to the large objects to have the new OID values. > Last I checked, they look in columns of types "oid" and "lo" (if "lo" > exists) for such references. Maybe you were engaging in some type > punning, like storing your references in int4 or int8 columns? > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org -- Jeremiah Jahn <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
