Re: [GENERAL] plpython error since upgrading from 7.x to 8.x

2005-05-25 Thread CSN
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

Re: [GENERAL] plpython error since upgrading from 7.x to 8.x

2005-05-25 Thread Michael Fuhr
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

Re: [GENERAL] plpython error since upgrading from 7.x to 8.x

2005-05-25 Thread CSN
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

Re: [GENERAL] plpython error since upgrading from 7.x to 8.x

2005-05-25 Thread Michael Fuhr
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