Re: BUG #5310: "NOT FOUND" throws "GetData to Procedure return failed." in stored functions - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5310: "NOT FOUND" throws "GetData to Procedure return failed." in stored functions
Date
Msg-id 522.1265221342@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5310: "NOT FOUND" throws "GetData to Procedure return failed." in stored functions  ("Lothar Bongartz" <lotharbongartz@hotmail.com>)
List 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 by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: BUG #5310: "NOT FOUND" throws "GetData to Procedure return failed." in stored functions
Next
From: Kelly SACAULT
Date:
Subject: Re: BUG #5308: How to disable Case sensitivity on naming identifiers