dumping large object comments

Started by Christopher Kings-Lynneover 21 years ago1 messages
#1Christopher Kings-Lynne
chriskl@familyhealth.com.au

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