From: thhal at mailblocks.com (Thomas Hallgren)
Date: Sat, 02 Jul 2005 20:47:41 +0200
Subject: [Pljava-dev] Aborting a transaction
In-Reply-To: <ce04e69f0507020816199822ca@mail.gmail.com>
References: <ce04e69f0507020816199822ca@mail.gmail.com>
	<42C6E14D.20409@mailblocks.com>
	<thhal-00XmiA+tzzzYWeLBFQnzYkqNfS6foVG@mailblocks.com>
Message-ID: <thhal-00XmiA+1zzzYL8HSykPfLVQzNmN/lLc@mailblocks.com>

Joao Afonso wrote:

>  Hi, 
>
>  I want to abort a transaction when a trigger on a table is fired.
>Anyone knows how to do this? Is it something that can be done with
>pl/java or rather at postgresql functions and procedures??
>
>  I read on the mailing list about a session manager and/or a
>transaction listener:
>  - http://gborg.postgresql.org/pipermail/pljava-dev/2005/000148.html
>
>  and about changing the _new resultset value:
>  - http://gborg.postgresql.org/pipermail/pljava-dev/2005/000149.html
>
>  Basically a trigger is fired before an Insert and calls a function
>that sends some data on a socket about the transaction. what i want to
>do is abort the insert...
>
>  Any help?
>  Thanks for all your great answers...
>_______________________________________________
>Pljava-dev mailing list
>Pljava-dev at gborg.postgresql.org
>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>  
>
The easiest way to abort is to simply throw an SQLException.

More advanced control can be obtained by using savepoints.

Regards,
Thomas Hallgren