[Pljava-dev] Obtaining Query from Trigger

Joao Afonso wrote:

> 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.
>
>
I'm sorry but no, that's not planned. I can't really see the use-case
where it would be really useful and it implies a fairly advanced
mechanism. Consider the following:

INSERT INTO foo(a,b) SELECT a,b FROM bar;

in combination with a "BEFORE INSERT ON EACH ROW" trigger on table foo.
What statement would you expect to see? Same thing is of course true for
updates and deletes that deals with several rows.

Perhaps I'd be able to help if you elaborate a bit on what you want to
use this for.

Regards,
Thomas Hallgren