agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] Obtaining Query from Trigger
Date: Wed, 08 Jun 2005 16:41:05 +0200
Message-ID: <thhal-0BJyCA79/zjYOU4phPh5U3grpT6C3SS@mailblocks.com> (raw)
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>

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

view thread (6+ messages)  latest in thread

Message-ID: <thhal-0BJyCA79/zjYOU4phPh5U3grpT6C3SS@mailblocks.com>
Permalink:  ../thhal-0BJyCA79%2FzjYOU4phPh5U3grpT6C3SS@mailblocks.com/
Also on:    postgresql.org/message-id/thhal-0BJyCA79/zjYOU4phPh5U3grpT6C3SS@mailblocks.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: <thhal-0BJyCA79/zjYOU4phPh5U3grpT6C3SS@mailblocks.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