Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group