From: | novnov <novnovice(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Trigger function that works with both updates and deletes? |
Date: | 2007-06-19 01:07:37 |
Message-ID: | 11186941.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Most of the trigger fuctions I've written work on new and updated records
referencing NEW. etc. I will need some of the trigger functions to work with
record deletions too.
First, when a record is being deleted, OLD refers to the rec just deleted
(or about to be deleted)?
Second, while I could write two trigger functions, one dealing with
add/update, the other with deletes, it's probably neater to have a single
trigger function and have it discriminate "am I being called for a delete,
or an add/update?" I don't know how to determine the type record change.
--
View this message in context: http://www.nabble.com/Trigger-function-that-works-with-both-updates-and-deletes--tf3943732.html#a11186941
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2007-06-19 01:36:59 | Re: Trigger function that works with both updates and deletes? |
Previous Message | Michael Glaesemann | 2007-06-18 22:02:31 | Re: statistics monitoring performance improvment -- 8.1 as well as 8.2 ? |