hi ben
trigger happens only a with dml update (you have to change something in the DB for the trigger to do its work)
Martin
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission.
> From: bench@silentmedia.com
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Can update triggers detect the column in the update statement?
> Date: Mon, 6 Oct 2008 17:24:37 -0700
>
> Say I have:
>
> create t (c1 int not null, c2 int);
>
> Is it possible to create an update trigger on t such updates will only
> be allowed if the update statement explicitly sets c1, even if the new
> value is the same?
>
>
> (I'm trying to write a change log system where the users are
> application users, not database users.)
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
Stay up to date on your PC, the Web, and your mobile phone with Windows Live.
See Now