Re: Can update triggers detect the column in the update statement?

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(at)silentmedia(dot)com
> To: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)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.
http://clk.atdmt.com/MRT/go/msnnkwxp1020093185mrt/direct/01/