[HACKERS] Feature request from irc...

2005-06-28 Thread Christopher Kings-Lynne
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 [EMAIL PROTECTED]

Re: [HACKERS] Feature request from irc...

2005-06-28 Thread Christopher Kings-Lynne
Use case is making a trigger than can log queries on tables... Christopher Kings-Lynne wrote: 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)---

Re: [HACKERS] Feature request from irc...

2005-06-28 Thread Denis Lussier
Title: [HACKERS] Feature request from irc... 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 ol

Re: [HACKERS] Feature request from irc...

2005-06-28 Thread Tom Lane
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > 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? What exactly is the use case for this? It cannot have anything to do with assuming that you know what has ha