Postgres Pro
Downloads
Home   >   mailing lists

Re: Audit Trigger puzzler - Mailing list pgsql-general

From Simon Riggs
Subject Re: Audit Trigger puzzler
Date
Msg-id 1251486460.4839.1458.camel@ebony.2ndQuadrant
Whole thread Raw
In response to Audit Trigger puzzler  (David Kerr <dmk@mr-paradox.net>)
Responses Re: Audit Trigger puzzler  (David Kerr <dmk@mr-paradox.net>)
List pgsql-general
Tree view 
On Fri, 2009-08-28 at 08:50 -0700, David Kerr wrote:

> so, is there a way in a trigger to know if edited_by is expressly
> being  set in the update statement? it seems like if I can know that,
> then i should be able to figure it out.

No, but you could use a before trigger to reset the value to NULL prior
to each update, then your after trigger would work.

--
 Simon Riggs           www.2ndQuadrant.com

pgsql-general by date:

Previous
From: Edwin Plauchu
Date:
Subject: Re: details locks
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: High load on commit after important schema changes