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

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 <mike(at)fuhr(dot)org> wrote:
> 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 function:
> >
> >
> > if TD["new"]["active"] != TD["old"]["active"]:
>
> Without a complete, self-contained example that
> succeeds in one
> version of PostgreSQL and fails in another, we still
> have to guess
> at what's going on. By "complete, self-contained
> example" I mean
> a sequence of SQL statements that anybody could load
> into an empty
> database and get the same results that you get.
> When putting
> together such an example, it's a good idea to reduce
> it as much as
> possible, i.e., keep removing things until you can't
> possibly make
> the example smaller and still get the behavior in
> question. Aside
> from making it easier for others to focus on the
> problem, sometimes
> the act of reducing the problem can help you find
> the problem on
> your own.
>
> My first guess would be that you're getting an error
> because when
> the event is INSERT, TD["old"] is None and thus
> unsubscriptable.
> But if that's the case then I'm not sure why the
> version of PostgreSQL
> would matter, and without seeing a complete example
> I'm not convinced
> that it does. Do you still get the error if you
> check if TD["event"]
> is "UPDATE" before trying to use TD["old"]?
>
> --
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/
>

__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new Resources site
http://smallbusiness.yahoo.com/resources/