Re: BUG #4061: after backup/restore pg_attrdef.adsrc column lacks schema name. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4061: after backup/restore pg_attrdef.adsrc column lacks schema name.
Date
Msg-id 19711.1206541413@sss.pgh.pa.us
Whole thread Raw
In response to BUG #4061: after backup/restore pg_attrdef.adsrc column lacks schema name.  ("Julius Tuskenis" <julius@nsoft.lt>)
List pgsql-bugs
"Julius Tuskenis" <julius@nsoft.lt> writes:
> Problem with backup/restore databases with schemas other than public. After
> restoring pg_attrdef.adsrc doesn't contain schema name of the sequence -
> only sequence itself. It is big problem then using Zeos lib components for
> Delphi, becouse they get wrong default values and no insert is possible
> then.

You need to file this bug against Zeos; if they are expecting adsrc to
contain anything very reliable then they are broken.  They shouldn't
be depending on it at all.  Note the comment at the bottom of
http://developer.postgresql.org/pgdocs/postgres/catalog-pg-attrdef.html

            regards, tom lane

pgsql-bugs by date:

Previous
From: Bill Moran
Date:
Subject: Re: BUG: PG do not use index
Next
From: Taiki Yamaguchi
Date:
Subject: DISTINCT MAX() results mismatch on 8.2 and 8.3