Date: Wed, 18 Sep 2013 13:53:37 +0200 (CEST)
From: Roberto Grandi <roberto.grandi@trovaprezzi.it>
To: Albe Laurenz <laurenz.albe@wien.gv.at>
Cc: pgsql-admin@postgresql.org
Message-ID: <515129598.391580.1379505217287.JavaMail.root@trovaprezzi.it>
In-Reply-To: 
 <A737B7A37273E048B164557ADEF4A58B17C21F41@ntex2010a.host.magwien.gv.at>
References: <1725603904.387654.1379499282544.JavaMail.root@trovaprezzi.it>
 <452256586.387717.1379499437400.JavaMail.root@trovaprezzi.it>
 <A737B7A37273E048B164557ADEF4A58B17C21F41@ntex2010a.host.magwien.gv.at>
Subject: Re: Catch exceptions outside function
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Thread-Topic: Catch exceptions outside function
Thread-Index: glZu2ImBDkpEo87LW1ODUNYiVViPYfCK5IjAaUmQHb8=
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Hi

this is my script in details, remember that I launch it by .Net code (devar=
t 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.albe@wien.gv.at>
A: "Roberto Grandi *EXTERN*" <roberto.grandi@trovaprezzi.it>, pgsql-admin@p=
ostgresql.org
Inviato: Mercoled=C3=AC, 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 wi=
thin script.
>=20
>=20
> BEGIN;
>=20
> -- raise an exception code
>=20
> EXCEPTION
> WHEN 'exception_type'
> THEN ROLLBACK;
>=20
> COMMIT;
>=20
> 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


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin