Re: Fix PL/Python metadata when there is no result

Peter Eisentraut <peter_e@gmx.net>

From: Peter Eisentraut <peter_e@gmx.net>
To: Jean-Baptiste Quenot <jbq@caraldi.com>
Cc: pgsql-hackers@postgresql.org
Date: 2012-04-15T17:27:06Z
Lists: pgsql-hackers
On fre, 2012-02-10 at 17:44 +0100, Jean-Baptiste Quenot wrote:
> Dear hackers,
> 
> Thanks for the work on PLPython result metadata, it is very useful!  I
> just came across a crash when trying to access this metadata on the
> result of an UPDATE, which obviously cannot return any tuple (unless
> you specify a RETURNING clause maybe?).
> 
> Please find attached a patch that solves this issue.  Instead of a PG
> crash, we get the following message:
> 
> ERROR:  plpy.Error: no result fetched

After much soul-searched about the API I have now committed your fix
that throws the exception.  Thanks.