Here is a patch to implement "Support triggers on columns" in our ToDo list.
The syntax is:
CREATE TRIGGER name
BEFORE UPDATE OF col1, col12, ...
ON tbl FOR EACH ROW EXECUTE PROCEDURE func();
I consulted the previous work following:
Column-level triggers (From: Greg Sabino Mullane, Date: 2005-07-04)
and completed some under-construction parts.
It's still arguable that we should add dependencies from column
triggers to referenced columns. In the present patch, dropeed
columns are just ignored and always considered as not-modified.
Please grep with "TODO: (TRIGGER)" to check the issue.
NTT Open Source Software Center
pgsql-hackers by date
|Next:||From: David Fetter||Date: 2009-09-03 02:10:18|
|Subject: Re: Triggers on columns|
|Previous:||From: Tom Lane||Date: 2009-09-03 01:41:40|
|Subject: Re: initdb: The password file was not generated. |