Catch exceptions outside function - Mailing list pgsql-admin

From Roberto Grandi
Subject Catch exceptions outside function
Date
Msg-id 452256586.387717.1379499437400.JavaMail.root@trovaprezzi.it
Whole thread Raw
Responses Re: Catch exceptions outside function  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Re: Catch exceptions outside function  (Igor Neyman <ineyman@perceptron.com>)
List pgsql-admin
Dear all

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?


Many thanks in advance.

Roberto


pgsql-admin by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Dumping a database that is not accepting commands?
Next
From: Albe Laurenz
Date:
Subject: Re: Catch exceptions outside function