Scott Corscadden <sc...@corscadden.ca> writes:
> ** MY QUESTION ** - Will pg_largeobject automatically choose new OIDs that
> don't conflict, if I've added lo's this way, by direct COPY?
In 8.4, yes. In later versions, you'd need to do something about
creating corresponding rows in pg_largeobject_metadata.
In general, all built-in OID columns have mechanisms for choosing
nonconflicting new values --- but in 9.0 and up, pg_largeobject_metadata
is the authoritative store of "existing OIDs" for blobs, not
pg_largeobject.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
