Postgres Pro
Downloads
Home   >   mailing lists

Re: Docs - Plpgsql trigger example auditing changes into another table - Mailing list pgsql-patches

From Tom Lane
Subject Re: Docs - Plpgsql trigger example auditing changes into another table
Date
Msg-id 1215.1102020216@sss.pgh.pa.us
Whole thread Raw
In response to Docs - Plpgsql trigger example auditing changes into another table  (Mark Kirkwood <markir@coretech.co.nz>)
Responses Re: Docs - Plpgsql trigger example auditing changes into  (Mark Kirkwood <markir@coretech.co.nz>)
List pgsql-patches
Tree view 
Mark Kirkwood <markir@coretech.co.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

pgsql-patches by date:

Previous
From: Mark Kirkwood
Date:
Subject: Docs - Plpgsql trigger example auditing changes into another table
Next
From: Mark Kirkwood
Date:
Subject: Re: Docs - Plpgsql trigger example auditing changes into