Re: Problems renaming referencing column

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Problems renaming referencing column
Дата
Msg-id
13124.1090080720@sss.pgh.pa.us
Ответ на
Problems renaming referencing column (Alexander M. Pravking)
Список
Дерево обсуждения
Problems renaming referencing column "Alexander M. Pravking" <fduch@antar.bryansk.ru>
Re: Problems renaming referencing column Tom Lane <tgl@sss.pgh.pa.us>
Re: Problems renaming referencing column Tom Lane <tgl@sss.pgh.pa.us>
Re: Problems renaming referencing column Stephan Szabo <sszabo@megazone.bigpanda.com>
"Alexander M. Pravking"  writes:
> In 7.4.3, if I rename a column which references another table,
> constraint trigger fails on update or delete from main table.

> The problem goes away after re-creating the foreign key:

Actually all you have to do is start a fresh backend.  The problem is
that the "ALTER TABLE slave" fails to force an update of the backend's
relcache entry for "master".  AFAICS this problem has always been there.
Certainly your test case yields a failure of some type in every release
back to 7.0 ...

			regards, tom lane
В списке pgsql-bugs по дате отправления
От: Theodore Petrosky
Дата:
Сообщение: Re: Replace function BUG
От: Tom Lane
Дата:
FAQ