plpgsql trigger original query

From: Dan99 <power919(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: plpgsql trigger original query
Date: 2007-09-11 01:50:31
Message-ID: 1189475431.097392.49490@22g2000hsm.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am looking for a way to get the original query that caused a trigger
to fire. I need to be able to get this query either inside the
trigger itself (and then send it to the function the trigger calls) or
get it in the end function. Is this doable? The reason i am asking is
that I would like to be able to send a variable (this variable would
come from php where the original query is executed) to the end
function called by the trigger.

Any help with this would be greatly appreciated.

Thanks,
Dan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrej Ricnik-Bay 2007-09-11 01:54:02 Re: Ubuntu libraries needed
Previous Message Tom Lane 2007-09-11 01:45:30 Re: Alternative to drop index, load data, recreate index?