Re: large object dump-restore problem(bug?)

Risko Peter  writes:
>   Here is my problem. The lo I restored has a new ID, and the description
> vanished. Is there a solution for this?

No, and no.  The LO *will* have a new OID; there's no alternative to
that.  pg_dump doesn't currently make any attempt to save descriptions
for large objects --- this might have something to do with the fact
that there's no official support for it (no COMMENT ON statement).
LO descriptions exist only in the mind of psql; they're a tad broken
even there, since that code doesn't work if you're not superuser.

			regards, tom lane