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-02-24T19:27:24Z
Lists: pgsql-hackers
On fre, 2012-02-10 at 17:44 +0100, Jean-Baptiste Quenot wrote:
> 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

Hmm, should it be an error or just return None?  Python DB-API
cursor.description returns None if no result set was returned.