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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Lothar Bongartz" <lotharbongartz(at)hotmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5310: "NOT FOUND" throws "GetData to Procedure return failed." in stored functions
Date: 2010-02-03 18:22:22
Message-ID: 522.1265221342@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Lothar Bongartz" <lotharbongartz(at)hotmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Kelly SACAULT 2010-02-03 19:13:56 Re: BUG #5308: How to disable Case sensitivity on naming identifiers
Previous Message Pavel Stehule 2010-02-03 17:58:55 Re: BUG #5310: "NOT FOUND" throws "GetData to Procedure return failed." in stored functions