Re: BUG #4061: after backup/restore pg_attrdef.adsrc column lacks schema name.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Julius Tuskenis" <julius(at)nsoft(dot)lt>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4061: after backup/restore pg_attrdef.adsrc column lacks schema name.
Date: 2008-03-26 14:23:33
Message-ID: 19711.1206541413@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Julius Tuskenis" <julius(at)nsoft(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message John Whitley 2008-03-26 22:12:50 BUG #4063: psql locks up on pager during dump restore
Previous Message Bill Moran 2008-03-26 13:22:18 Re: BUG: PG do not use index