|
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@xxxxxxxxxxxxxxx > To: pgsql-general@xxxxxxxxxxxxxx > 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@xxxxxxxxxxxxxx) > 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 |
