Ah, you're right. The function appears to only cause
an error on inserts and not updates. Thanks for
pointing that out (I'm really green at Python).
CSN
--- Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Wed, May 25, 2005 at 12:02:22PM -0700, CSN wrote:
> >
> > It happens when I try to insert ro
On Wed, May 25, 2005 at 12:02:22PM -0700, CSN wrote:
>
> It happens when I try to insert rows:
>
> insert into table1 (col1, col2, col3) values (val1,
> val2, val3);
>
> I have an insert/update trigger on that table, and the
> plpythonu function just sends a notification email.
> Here's the func
It happens when I try to insert rows:
insert into table1 (col1, col2, col3) values (val1,
val2, val3);
I have an insert/update trigger on that table, and the
plpythonu function just sends a notification email.
Here's the function:
if TD["new"]["active"] != TD["old"]["active"]:
import
On Wed, May 25, 2005 at 02:04:22AM -0700, CSN wrote:
>
> I had a plpythonu function that worked in 7.x but
> since upgrading to 8.x it's giving this error:
>
> ERROR: plpython: function "notify" failed
> DETAIL: exceptions.TypeError: unsubscriptable object
Could you post a simple, self-containe