From: | Roberto Grandi <roberto(dot)grandi(at)trovaprezzi(dot)it> |
---|---|
To: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Catch exceptions outside function |
Date: | 2013-09-18 11:53:37 |
Message-ID: | 515129598.391580.1379505217287.JavaMail.root@trovaprezzi.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi
this is my script in details, remember that I launch it by .Net code (devart connector):
SET LOCAL statement_timeout TO 1000;
BEGIN;
SELECT pg_sleep(5); -- QUERY that is long running;
-- Some exception catch such as EXCEPTION
END;
I supposed my code can throw an eception for timeout and I would catch it. Otherwise consecutives queries report "Transaction is aborted message error".
Do you have any suggestion for me?
Thanks again
Roberto
----- Messaggio originale -----
Da: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
A: "Roberto Grandi *EXTERN*" <roberto(dot)grandi(at)trovaprezzi(dot)it>, pgsql-admin(at)postgresql(dot)org
Inviato: Mercoledì, 18 settembre 2013 12:41:01
Oggetto: RE: Catch exceptions outside function
Roberto Grandi wrote:
> I ask for your help cause I can't point out the solution to my problem on PG 8.3
> I would catch an exception outside any function/procedure but directly within script.
>
>
> BEGIN;
>
> -- raise an exception code
>
> EXCEPTION
> WHEN 'exception_type'
> THEN ROLLBACK;
>
> COMMIT;
>
> is it possible with PG 8.3?
That's a bit unclear.
What do you mean by "outside a function but in a script"?
Can you explain in more detail?
The code sample you paste looks like PL/pgSQL.
You cannot commit or roll back in PL/pgSQL.
If you want to undo in case of error whatever happens in the block,
just replace the ROLLBACK with NOOP.
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2013-09-18 12:57:50 | Re: Catch exceptions outside function |
Previous Message | Albe Laurenz | 2013-09-18 10:41:01 | Re: Catch exceptions outside function |