Re: Feature request from irc... - Mailing list pgsql-hackers

From Denis Lussier
Subject Re: Feature request from irc...
Date
Msg-id B319CFEC3B80D3408CA36F99ADE840940F28FD@edb-dc1.Edb-net.EnterpriseDB.com
Whole thread Raw
In response to Feature request from irc...  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
I personally think it's an interesting idea.  Is there a business scenario where you want/need to do this??  I think it'd be kinda cool for a trigger to be able to write out an audit record with the dml sql (along with the typical old, and new value stuff).   Perhaps this is already doable??


From: pgsql-hackers-owner@postgresql.org on behalf of Christopher Kings-Lynne
Sent: Tue 6/28/2005 11:54 PM
To: Hackers
Subject: [HACKERS] Feature request from irc...

Is it possible for a pl/pgsql trigger function to look at the sql
command that caused it to be triggered?  If not, is this an idea?

Chris

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Open items
Next
From: Tom Lane
Date:
Subject: Re: Odd message with initdb on latest HEAD