| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Roberto Grandi *EXTERN*" <roberto(dot)grandi(at)trovaprezzi(dot)it>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Catch exceptions outside function |
| Date: | 2013-09-18 10:41:01 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B17C21F41@ntex2010a.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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 | Roberto Grandi | 2013-09-18 11:53:37 | Re: Catch exceptions outside function |
| Previous Message | Roberto Grandi | 2013-09-18 10:17:17 | Catch exceptions outside function |