Re: Audit Trigger puzzler

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: David Kerr <dmk(at)mr-paradox(dot)net>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Audit Trigger puzzler
Date: 2009-08-28 19:07:40
Message-ID: 1251486460.4839.1458.camel@ebony.2ndQuadrant
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steven Lembark 2009-08-28 19:13:47 Question on round-robin partitioning
Previous Message Edwin Plauchu 2009-08-28 16:52:53 Re: details locks