Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group