Re: SQLSTATE again

This patch is has been removed from the patch queue for the following
reason:

---------------------------------------------------------------------------

This patch is not ready to be applied -- we're waiting for Pavel to
submit a revised version with the semantics described here:

http://archives.postgresql.org/pgsql-committers/2005-06/msg00017.php

---------------------------------------------------------------------------

Pavel Stehule wrote:
> Hello
>
> I changed implementation of SQLSTATE from block scope variables on
> function scope variables. I am not sure if it's moust elegant solution,
> but is very similar Oracle behavior (there is session scope variable)
>
> CREATE OR REPLACE FUNCTION ff() RETURNS void AS $$
> BEGIN
> RAISE NOTICE 'No exception: % %', SQLSTATE, SQLERRM;
> DECLARE x integer;
> BEGIN
> x := 10/0;
> EXCEPTION WHEN OTHERS THEN
> BEGIN
> RAISE NOTICE 'Div: % %', SQLSTATE, SQLERRM;
> BEGIN
> RAISE NOTICE 'Div2: % %', SQLSTATE, SQLERRM;
> RAISE EXCEPTION 'My user exception';
> EXCEPTION WHEN OTHERS THEN
> RAISE NOTICE 'User: % %', SQLSTATE, SQLERRM;
> END;
> RAISE NOTICE '1: % %', SQLSTATE, SQLERRM;
> END;
> RAISE NOTICE '2: % %', SQLSTATE, SQLERRM;
> END;
> RAISE NOTICE '3: % %', SQLSTATE, SQLERRM;
> END;
> $$ LANGUAGE plpgsql;
> select ff();
>
>
> NOTICE: No exception: 00000 Successful completion
> NOTICE: Div: 22012 division by zero
> NOTICE: Div2: 22012 division by zero
> NOTICE: User: P0001 My user exception
> NOTICE: 1: 00000 Successful completion
> NOTICE: 2: 00000 Successful completion
> NOTICE: 3: 00000 Successful completion
>
> Any comments?
>
> Regards
> Pavel Stehule
>
>

Content-Description:

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073