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.
the relevant output from pg_restore:
pg_restore: restoring data for table "BLOBS"
pg_restore: connecting to database "copa" as user "copa"
pg_restore: creating table for large object cross-references
pg_restore: restored 5575606 large objects
pg_dump -F c -v -b -o -U copa copa > judici.pgsql
pg_restore -C -d template1 -F c -v -U copa < europa/judici.pgsql
thanx,
-jj-
--
Jeremiah Jahn <jeremiah(at)cs(dot)earlham(dot)edu>