agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] Obtaining Query from Trigger
Date: Wed, 8 Jun 2005 15:20:57 +0100
Message-ID: <ce04e69f05060807207c684553@mail.gmail.com> (raw)
In-Reply-To: <thhal-0XCeCAwV9zjYkHoY0KllhRjVR7BiY28@mailblocks.com>
References: <42A68EDA.1090206@mailblocks.com>
	<ce04e69f050607150868a9b80e@mail.gmail.com>
	<thhal-0XCeCAwV9zjYkHoY0KllhRjVR7BiY28@mailblocks.com>

  Ok, my mistake... I'll need to think of something else. But I still
need to get the query that fired on an insert, update or delete. Could
you help me with that??

  Thanks in advance.


On 6/8/05, Thomas Hallgren <thhal at mailblocks.com> wrote:
> Joao Afonso wrote:
> 
> >  Hi!
> >
> >  I started using pljava two days ago, so I apologize if this was
> >already posted before.
> >
> >  I need to get the sql query that fired a trigger on a DB so that it
> >can be re-issued to another DB.
> >
> >  For example, if 'select * from users' fired a before select trigger,
> >the string with the query should be somehow passed to the java
> >function that is associated to that trigger.
> >
> >
> I hate to dissapoint you but to my knowledge a trigger is never fired
> for SELECT. Only INSERT, UPDATE, and DELETE will fire triggers.
> 
> Regards,
> Thomas Hallgren
> 
> 
>

view thread (6+ messages)  latest in thread

Message-ID: <ce04e69f05060807207c684553@mail.gmail.com>
Permalink:  ../ce04e69f05060807207c684553@mail.gmail.com/
Also on:    postgresql.org/message-id/ce04e69f05060807207c684553@mail.gmail.com

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] Obtaining Query from Trigger
  In-Reply-To: <ce04e69f05060807207c684553@mail.gmail.com>

* 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