Re: Docs - Plpgsql trigger example auditing changes into another table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mark Kirkwood <markir(at)coretech(dot)co(dot)nz>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Docs - Plpgsql trigger example auditing changes into another table
Date: 2004-12-02 20:43:36
Message-ID: 1215.1102020216@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Mark Kirkwood <markir(at)coretech(dot)co(dot)nz> writes:
> This patch adds another plpgsql trigger example to the chapter. It uses
> the emp table again, but shows how to audit changes into another table
> (emp_audit).

Should be an AFTER trigger, else you may be recording the wrong data, or
even an event that didn't happen at all.

regards, tom lane

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Mark Kirkwood 2004-12-02 21:14:48 Re: Docs - Plpgsql trigger example auditing changes into
Previous Message Mark Kirkwood 2004-12-02 20:34:41 Docs - Plpgsql trigger example auditing changes into another table