[Pljava-dev] how to cancel a trigger operation

Hi Jon, for many reasons:

-All my project is java. It is a spatial extension for postgres and h2
-plpgsql is not working because i need to know the column names so i can use NEW.something or OLD.something..so and other stuff
i have to use C or plpython or Pljava
-pljava works perfect with triggers but it has the problem i mentioned

so my question is related just with PLJAVA and Triggers. I already know how to solve that in C or other pl languages.
Cheers,
Jose

Subject: RE: [Pljava-dev] how to cancel a trigger operation
Date: Fri, 19 Mar 2010 10:31:45 -0500
From: Jon.Roberts at asurion.com
To: jcllario at hotmail.com; pljava-dev at pgfoundry.org

I?ll bite. Why are you using triggers? Why are you using Java
for the trigger code?

Jon

From: pljava-dev-bounces at pgfoundry.org
[mailto:pljava-dev-bounces at pgfoundry.org] On Behalf Of JOSE CARLOS
MARTINEZ LLARIO

Sent: Friday, March 19, 2010 10:02 AM

To: pljava-dev at pgfoundry.org

Subject: [Pljava-dev] how to cancel a trigger operation

Hi all, Im sending this email again to the list because I really need to get an answer for

the pljava developers or someone who can help me.

Im wondering how to cancel a trigger operation.

Throwing an exception works but not in the way i need because the transaction is aborted.

I was looking for something that I already read in this list:

http://pgfoundry.org/pipermail/pljava-dev/2006/001000.html

http://pgfoundry.org/pipermail/pljava-dev/2006/001001.html

I was expecting someone already fixed that bug (i think its a bug because we can not use triggers in a proper way) because

these posts are from 4 years ago.

Has someone already worked in this bug?

Thanks to all,

Best,

Jose

Actual?zate
gratis al nuevo Internet Explorer 8 y navega m?s seguro

_________________________________________________________________
?Te gustar?a tener Hotmail en tu m?vil Movistar? ?Es gratis!
http://serviciosmoviles.es.msn.com/hotmail/movistar-particulares.aspx
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20100319/7b29364b/attachment.html>