Re: TRIGGERS - access sql query_string that called it? - Mailing list pgsql-general

From Richard Huxton
Subject Re: TRIGGERS - access sql query_string that called it?
Date
Msg-id 4552F40D.2010307@archonet.com
Whole thread Raw
In response to TRIGGERS - access sql query_string that called it?  (Matthew Peter <survivedsushi@yahoo.com>)
List pgsql-general
Matthew Peter wrote:
> Is it possible to access the entire sql query_string that called the trigger?

No. It doesn't necessarily exist in any useful form (think about what
happens with rules on a view, or triggers making updates which fire
other triggers - what is the "original" query?).

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: RULE - special variables?
Next
From: Richard Huxton
Date:
Subject: Re: dblink / plpgsql - definition list cheats for record