From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | Mark Kirkwood <markir(at)coretech(dot)co(dot)nz> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-patches(at)postgresql(dot)org |
Subject: | Re: Docs - Plpgsql trigger example auditing changes into |
Date: | 2004-12-03 19:39:31 |
Message-ID: | 20041203193931.GA25380@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
On Fri, Dec 03, 2004 at 10:14:48AM +1300, Mark Kirkwood wrote:
> Tom Lane wrote:
>
> >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.
> >
> Thanks Tom - I was busy checking the spelling, but didn't check if
> it was functionally correct :-(
It occurs to me that this might be a place to demo table inheritance
too, to ease automating the creation, etc. of the auditing
infrastructure :)
Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-12-03 20:37:41 | Re: utf-8 flag always off in plperl function arguments |
Previous Message | David Kamholz | 2004-12-03 18:16:55 | utf-8 flag always off in plperl function arguments |