From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | Derry Bryson <derry_bryson(at)yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Get Query in Statement Level Trigger? |
Date: | 2005-07-02 03:04:57 |
Message-ID: | 20050702030457.GB16560@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Stark | 2005-07-02 06:20:08 | Re: Transparent i18n? |
Previous Message | Michael Fuhr | 2005-07-02 02:46:13 | Re: cross references queries |