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