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 по дате отправления