[Pljava-dev] Aborting a transaction

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