Re: BUG #1620: triggers breaks with alter table (at least with plpythonu)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #1620: triggers breaks with alter table (at least with plpythonu)
Дата
Msg-id 23933.1114299922@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #1620: triggers breaks with alter table (at least with plpythonu)  ("Nahuel Greco" <ngreco@gmail.com>)
Список pgsql-bugs
"Nahuel Greco" <ngreco@gmail.com> writes:
> If I create a trigger for a table, the trigger works
> ok, but if I add a new column to the table, then
> the trigger receives a NEW record with the old
> structure! I can fix that only if I remove the trigger
> from the table _and_ the trigger function.

Starting a fresh backend session would be sufficient.  I believe the
issue is that plpython is caching tuple structure information.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Transactions and "create or replace function"
Следующее
От: Dennis Vshivkov
Дата:
Сообщение: Re: BUG #1618: EXTRACTing EPOCH from TIME WITH TIME ZONE is broken