agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] PLJAVA Trigger Function more arguments
Date: Wed, 2 Nov 2005 11:49:23 +0000 (UTC)
Message-ID: <loom.20051102T124317-786@post.gmane.org> (raw)

Hello 

I have a question, I have defined a java trigger and I want send from 
PostgreSQL more arguments than the TriggerData object

I have the following code

CREATE TRIGGER tu_elementos_instalacion_monitorizar_tr
  AFTER UPDATE
  ON elementos_instalacion_monitorizar
  FOR EACH ROW
  EXECUTE PROCEDURE sendudpmessagetr('valor');

CREATE OR REPLACE FUNCTION sendudpmessagetr()
  RETURNS "trigger" AS
'tekniker.udpip.SendUdpMessage.sendudpmessagetr'
  LANGUAGE 'javau' VOLATILE;
ALTER FUNCTION sendudpmessagetr() OWNER TO optemi;

public static void sendudpmessagetr(TriggerData td) throws SQLException{...}   

My question is that if is it possible define 

public static void sendudpmessagetr(TriggerData td, String str1, String str2) 
throws SQLException{...}  

Or if it is possible to define inside the TriggerData more arguments because I 
have see in documentation that is avaliable the getArguments() method, but I 
don?t know how define these new arguments in the TRIGGER function

Thanks in advance for your help

Nacho

view thread (10+ messages)  latest in thread

Message-ID: <loom.20051102T124317-786@post.gmane.org>
Permalink:  ../loom.20051102T124317-786@post.gmane.org/
Also on:    postgresql.org/message-id/loom.20051102T124317-786@post.gmane.org

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] PLJAVA Trigger Function more arguments
  In-Reply-To: <loom.20051102T124317-786@post.gmane.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox