Postgres Pro
Downloads
Home   >   mailing lists

Re: Trigger for Audit Table - Mailing list pgsql-general

From Bill Moseley
Subject Re: Trigger for Audit Table
Date
Msg-id 20070310042302.GA24082@hank.org
Whole thread Raw
In response to Re: Trigger for Audit Table  ("ksherlock@gmail.com" <ksherlock@gmail.com>)
List pgsql-general
Tree view 
On Fri, Mar 09, 2007 at 01:27:51PM -0800, ksherlock@gmail.com wrote:
> You can/should create it as an AFTER UPDATE trigger.  The OLD row will
> contain the previous values.

Curiously, also works with a BEFORE UPDATE.

Off to review the docs....

--
Bill Moseley
moseley@hank.org

pgsql-general by date:

Previous
From: omar
Date:
Subject: Re: OT: Canadian Tax Database
Next
From: "Ted Byers"
Date:
Subject: Data validation - was Re: OT: Canadian Tax Database