From: joaoaafonso at gmail.com (Joao Afonso)
Date: Sat, 2 Jul 2005 16:16:53 +0100
Subject: [Pljava-dev] Aborting a transaction
Message-ID: <ce04e69f0507020816199822ca@mail.gmail.com>

  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...