pg_largeobject and oid mistmach after restore - Mailing list pgsql-general

From Jeremiah Jahn
Subject pg_largeobject and oid mistmach after restore
Date
Msg-id 1075142523.9446.167.camel@bluejay.goodinassociates.com
Whole thread Raw
Responses Re: pg_largeobject and oid mistmach after restore  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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@cs.earlham.edu>


pgsql-general by date:

Previous
From: Nuno Morgadinho
Date:
Subject: Executing a query and returning the result set using the SPI
Next
From: Karsten Hilbert
Date:
Subject: how to enumerate rows ?!?