Re: 7.3.3 - plpython & trigger problem - Mailing list pgsql-bugs

From Arthur Ward
Subject Re: 7.3.3 - plpython & trigger problem
Date
Msg-id 3EE79697.12005.CCC15E8@localhost
Whole thread Raw
In response to Re: 7.3.3 - plpython & trigger problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
> > No, it does not match what I'm seeing. To check, I dropped my test
> > table and function, exited psql, started psql, and ran the script I
> > originally posted. I still get the same results. If I had to guess, this
> > seems more like a Postgres to plpython conversion problem than a
> > caching problem.
>
> Bingo.  The conversion-method-selection code is not only broken (for
> several datatypes besides this one), but quite wrongheaded (testing on
> the name of the datatype is the wrong approach).  I've applied the
> attached patch; please confirm it works for you.

Applied successfully to 7.3.3 and the bug in question is fixed for my
situation. Thanks a bunch for the quick fix!

Now to implement the workaround for the plpython trigger &
rowtype caching problem...

--
Arthur Ward

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: valgrind
Next
From: "Zíka Aleš, Ing."
Date:
Subject: Bug in SQL function with returntype void