| From: | Mark Kirkwood <markir(at)coretech(dot)co(dot)nz> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: Docs - Plpgsql trigger example auditing changes into |
| Date: | 2004-12-02 21:14:48 |
| Message-ID: | 41AF85C8.7050103@coretech.co.nz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
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 :-(
New patch attached.
| Attachment | Content-Type | Size |
|---|---|---|
| plpgsql.sgml.diff | text/plain | 2.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2004-12-02 22:21:04 | Re: contrib/xml2: add function xml_encode_special_chars |
| Previous Message | Tom Lane | 2004-12-02 20:43:36 | Re: Docs - Plpgsql trigger example auditing changes into another table |