On Sat, 2005-01-01 at 14:10 -0500, Tom Lane wrote:
Korry <[EMAIL PROTECTED]> writes:
> It seems you can’t trap every condition listed in errocodes-
> appendix.html; in particular, you can’t trap SUCCESSFUL_COMPLETION, any
> of the conditions listed in the WARNING category, or any of the
> con
Korry <[EMAIL PROTECTED]> writes:
> It seems you can’t trap every condition listed in errocodes-
> appendix.html; in particular, you can’t trap SUCCESSFUL_COMPLETION, any
> of the conditions listed in the WARNING category, or any of the
> conditions listed in the NO DATA category. (At least throug
On Sat, Jan 01, 2005 at 10:04:57AM -0500, Korry wrote:
> It seems you can???t trap every condition listed in errocodes-
> appendix.html; in particular, you can't trap SUCCESSFUL_COMPLETION, any
> of the conditions listed in the WARNING category, or any of the
> conditions listed in the NO DATA cat
I am using the following sytex to handle exceptions in
plpgsql (I am using postgres 8 rc1)
some code
EXCEPTION
WHEN NO_DATA THEN
RAISE NOTICE 'NO DATA';
WHEN OTHERS THEN
RAISE NOTICE 'An exception occurred';
RETURN emp_rec;
and i receive the f
Michael Fuhr wrote:
On Fri, Dec 31, 2004 at 03:18:39PM -0500, Andrew Dunstan wrote:
It has told you what the problem is. Use a handler for an exception that
actually exists. To see what these are, read
http://developer.postgresql.org/docs/postgres/plpgsql-errors-and-messages.html
As the
On Fri, Dec 31, 2004 at 03:18:39PM -0500, Andrew Dunstan wrote:
> It has told you what the problem is. Use a handler for an exception that
> actually exists. To see what these are, read
> http://developer.postgresql.org/docs/postgres/plpgsql-errors-and-messages.html
As the PL/pgSQL "Trapping Er
PEBKAC.
It has told you what the problem is. Use a handler for an exception that
actually exists. To see what these are, read
http://developer.postgresql.org/docs/postgres/plpgsql-errors-and-messages.html
cheers
andrew
Sibtay Abbas wrote:
hello
I am using the following sytex to handle exceptions
hello
I am using the following sytex to handle exceptions in
plpgsql (I am using postgres 8 rc1)
some code
EXCEPTION
WHEN NO_DATA THEN
RAISE NOTICE 'NO DATA';
WHEN OTHERS THEN
RAISE NOTICE 'An exception occurred';
RETURN emp_rec;
and i receive
