I just remembered that although we now have COMMENT ON LARGE OBJECT 
<oid>, we haven't changed pg_dump to dump and restore these comments.

I went ahead and did this, but then realised that I cannot just dump the 
comments normally as the oid the lob is assigned when it's restored is 
not necessarily going to be the same as it was before.

So, somehow I guess we have to store the comments in some way that when 
the lob is imported, and we get its oid (i assume lo_import returns it) 
we insert the comment then.  It seems that this would require 
complicated changes to the way lobs and their comments are stored.

Any other ideas?

Chris

Mon, 02 Aug 2004 10:17:46 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
dumping large object comments