Re: plpythonu: how to catch plpy.execute() exceptions

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