Re: plpythonu: how to catch plpy.execute() exceptions - Mailing list pgsql-admin

From Joshua D. Drake
Subject Re: plpythonu: how to catch plpy.execute() exceptions
Date
Msg-id 1288369641.2355.17.camel@jd-desktop
Whole thread Raw
In response to Re: plpythonu: how to catch plpy.execute() exceptions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Sergey Konoplev
Date:
Subject: Re: plpythonu: how to catch plpy.execute() exceptions
Next
From: Gerhard Hintermayer
Date:
Subject: Re: Minor upgrade procedure while DB up & running