Re: BUG #1620: triggers breaks with alter table (at least with plpythonu) - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1620: triggers breaks with alter table (at least with plpythonu)
Date
Msg-id 23933.1114299922@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1620: triggers breaks with alter table (at least with plpythonu)  ("Nahuel Greco" <ngreco@gmail.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Transactions and "create or replace function"
Next
From: Dennis Vshivkov
Date:
Subject: Re: BUG #1618: EXTRACTing EPOCH from TIME WITH TIME ZONE is broken