Hello I have new version. I'll send it early.
Regards Pavel Stehule On Sat, 4 Jun 2005, Bruce Momjian wrote: > > Your patch has been added to the PostgreSQL unapplied patches list at: > > http://momjian.postgresql.org/cgi-bin/pgpatches > > It will be applied as soon as one of the PostgreSQL committers reviews > and approves it. > > --------------------------------------------------------------------------- > > > 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 > > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
