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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings