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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #4061: after backup/restore pg_attrdef.adsrc column lacks schema name.
Дата
Msg-id 19711.1206541413@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #4061: after backup/restore pg_attrdef.adsrc column lacks schema name.  ("Julius Tuskenis" <julius@nsoft.lt>)
Список 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 по дате отправления:

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: BUG: PG do not use index
Следующее
От: Taiki Yamaguchi
Дата:
Сообщение: DISTINCT MAX() results mismatch on 8.2 and 8.3