Re: BUG #5310: "NOT FOUND" throws "GetData to Procedure return failed." in stored functions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #5310: "NOT FOUND" throws "GetData to Procedure return failed." in stored functions
Дата
Msg-id 522.1265221342@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #5310: "NOT FOUND" throws "GetData to Procedure return failed." in stored functions  ("Lothar Bongartz" <lotharbongartz@hotmail.com>)
Список pgsql-bugs
"Lothar Bongartz" <lotharbongartz@hotmail.com> writes:
> A "NOT FOUND" condition in a stored function throws a "GetData to Procedure
> return failed." error, which cannot be trapped by the EXCEPTION handling.

There is no such error message text anywhere in Postgres, and you
haven't given enough context to let anyone guess what the complaint
actually is about.  Please show a *complete* example not a one-line
extract.

The expected behavior of the command you show is to set the INTO
variable(s) to NULL if there is no matching row.  That isn't an
error though.

            regards, tom lane

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: BUG #5310: "NOT FOUND" throws "GetData to Procedure return failed." in stored functions
Следующее
От: Kelly SACAULT
Дата:
Сообщение: Re: BUG #5308: How to disable Case sensitivity on naming identifiers