| From: | David Kerr <dmk(at)mr-paradox(dot)net> |
|---|---|
| To: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Audit Trigger puzzler |
| Date: | 2009-08-31 15:48:24 |
| Message-ID: | 20090831154824.GC87434@mr-paradox.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Aug 28, 2009 at 08:07:40PM +0100, Simon Riggs wrote:
-
- On Fri, 2009-08-28 at 08:50 -0700, David Kerr wrote:
-
- > so, is there a way in a trigger to know if edited_by is expressly
- > being set in the update statement? it seems like if I can know that,
- > then i should be able to figure it out.
-
- No, but you could use a before trigger to reset the value to NULL prior
- to each update, then your after trigger would work.
hmm, that's probably not worth it. fireing two triggers just to get an
edited_by column filled in.
Thanks
Dave
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hrishikesh Mehendale | 2009-08-31 16:44:52 | Re: indexes on partitioned tables - on the base table, or the partitioned tables? |
| Previous Message | Tom Lane | 2009-08-31 15:40:40 | Re: Looking for "proper" escape string syntax from pg_get_constraintdef |