Can update triggers detect the column in the update statement?

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Can update triggers detect the column in the update statement?
Date: 2008-10-07 00:24:37
Message-ID: 90146BCC-5499-4F84-873D-F81E2876DC3C@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Klint Gore 2008-10-07 00:33:51 Re: feature idea
Previous Message Tom Lane 2008-10-06 23:06:58 Re: feature idea