Re: Problems with renaming a column

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problems with renaming a column
Дата
Msg-id 9828.1054576850@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Problems with renaming a column  (Rod Taylor <rbt@rbt.ca>)
Ответы Re: Problems with renaming a column  (Rod Taylor <rbt@rbt.ca>)
Список pgsql-hackers
Rod Taylor <rbt@rbt.ca> writes:
> As you can see below, after a rename the check constraint still refers
> to 'col' and not 'newname' as pg_constraint.consrc is not updated.

The same issue has always existed with regard to pg_attrdef.adsrc.
pg_dump ought to be using the binary column not the source column, just
as it does for default expressions.

> It seems this is a problem in 7.3 as well.  I believe the solution is to
> outright remove consrc, and enable the interface to request a text
> version of conbin on the fly.

I do not think we need to remove the column.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Status during copy [patch]
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Proposal for Re-ordering CONF (was: Re: GUC and postgresql.conf docs)