From: thhal at mailblocks.com (Thomas Hallgren)
Date: Wed, 08 Jun 2005 16:41:05 +0200
Subject: [Pljava-dev] Obtaining Query from Trigger
In-Reply-To: <ce04e69f05060807207c684553@mail.gmail.com>
References: <42A68EDA.1090206@mailblocks.com>
	<ce04e69f050607150868a9b80e@mail.gmail.com>
	<thhal-0XCeCAwV9zjYkHoY0KllhRjVR7BiY28@mailblocks.com>
	<ce04e69f05060807207c684553@mail.gmail.com>
	<42A70381.7060801@mailblocks.com>
	<thhal-0BJyCA71/zjY1rTR2es9iWrUdMVc4gY@mailblocks.com>
Message-ID: <thhal-0BJyCA79/zjYOU4phPh5U3grpT6C3SS@mailblocks.com>

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