Re: Get Query in Statement Level Trigger?

--- Michael Fuhr <mike(at)fuhr(dot)org> wrote:

> 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?
>

This is for replication. Currently I do it on row
level, but that generates lots of updates for queries
like 'delete from xxxx' where xxxx has lots of rows
which tends to bog down the replication. What I was
hoping to do was replicate on a query level.

Thanks,

Derry Bryson

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com