Re: Get Query in Statement Level Trigger?

On Thu, Jun 30, 2005 at 10:56:21AM -0700, Derry Bryson wrote:
>
> Is it possible to get the text of the query that
> caused the trigger within a statement level trigger?

Not as far as I know -- somebody please correct me if I'm mistaken.
Querying pg_stat_activity or calling pg_stat_get_backend_activity()
don't work because of the lag in the statistics collector.

> It looks to me like all you can get is whether it is a
> an UPDATE, DELETE, or INSERT and not much in the way
> of details about the what caused the trigger.

You can get a little more information than that, but probably not
what you're after:

http://www.postgresql.org/docs/8.0/static/plpgsql-trigger.html

What information are you looking for and why?  What problem are you
trying to solve?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/