[Pljava-dev] Aborting a transaction

[Thomas Hallgren]

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