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.