Re: large object dump-restore problem(bug?) - Mailing list pgsql-general

From Tom Lane
Subject Re: large object dump-restore problem(bug?)
Date
Msg-id 26230.1019833432@sss.pgh.pa.us
Whole thread Raw
In response to large object dump-restore problem(bug?)  (Risko Peter <peter@risko.hu>)
List pgsql-general
Risko Peter <peter@risko.hu> 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

pgsql-general by date:

Previous
From: "Riebs, Andy"
Date:
Subject: Re: intel vs amd benchmark for pg server
Next
From: fathi.engineer@gnet.tn
Date:
Subject: Pam Authentication help needed