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

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Fix PL/Python metadata when there is no result
Дата
Msg-id 1330111644.32452.20.camel@vanquo.pezone.net
обсуждение исходный текст
Ответ на Fix PL/Python metadata when there is no result  (Jean-Baptiste Quenot <jbq@caraldi.com>)
Ответы Re: Fix PL/Python metadata when there is no result  (Jean-Baptiste Quenot <jbq@caraldi.com>)
Список 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.




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Triggers with DO functionality
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Triggers with DO functionality