Re: Trigger for Audit Table

From: Bill Moseley <moseley(at)hank(dot)org>
To: "ksherlock(at)gmail(dot)com" <ksherlock(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Trigger for Audit Table
Date: 2007-03-10 04:23:03
Message-ID: 20070310042302.GA24082@hank.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Mar 09, 2007 at 01:27:51PM -0800, ksherlock(at)gmail(dot)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(at)hank(dot)org

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stefan Berglund 2007-03-10 04:28:40 Is This A Set Based Solution?
Previous Message omar 2007-03-10 03:40:53 Re: OT: Canadian Tax Database