On Fri, 2010-10-29 at 10:03 -0400, Tom Lane wrote:
> Dragos Valentin Moinescu <dragos.moinescu@gmail.com> writes:
> > The thing is that I cannot catch the exception raised by plpy.execute().
>
> Yeah, plpython's error handling is fundamentally broken. Somebody
> needs to rewrite it to be more like the other PLs. In the meantime,
> I'd suggest using plperl, which has gotten a lot more love than
> plpython ever did.
Or take a look at pg-python:
http://pgfoundry.org/projects/python/
Which is much more actively maintained and still Python.
JD
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt