[Pljava-dev] Obtaining Query from Trigger

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