I just had a thought for something I'm doing. Can't I just copy a large object
into a new one by doing something like:
INSERT INTO pg_largeobject
SELECT anewoid, pageno, data FROM pg_largeobject WHERE oid = srcid
?
How do I get the new oid? There's not a sequence to get the next one is there?
--
Nigel J. Andrews