From: Joshua D. Drake <jd@commandprompt.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Dragos Valentin Moinescu <dragos.moinescu@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: plpythonu: how to catch plpy.execute() exceptions
Date: Fri, 29 Oct 2010 09:27:21 -0700
Message-ID: <1288369641.2355.17.camel@jd-desktop> (raw)
In-Reply-To: <671.1288361031@sss.pgh.pa.us>
References: <AANLkTi=aaz=kv_08QH1tGPhK4b_Q1TwRk1tMbQX3fWVk@mail.gmail.com>
<671.1288361031@sss.pgh.pa.us>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jd@commandprompt.com, tgl@sss.pgh.pa.us, dragos.moinescu@gmail.com
Subject: Re: plpythonu: how to catch plpy.execute() exceptions
In-Reply-To: <1288369641.2355.17.camel@jd-desktop>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox