Re: Update a single row without firing its triggers?

From: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
To: <dmitry(at)koterov(dot)ru>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Update a single row without firing its triggers?
Date: 2007-07-07 15:48:40
Message-ID: C2B511F8.79263%scott_ribe@killerbytes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Why not just write the trigger function as:

if old.a is distinct from new.a or old.b is distinct from new.b
...
end if

--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 722-0567 voice

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2007-07-07 16:25:52 Arrays of records?
Previous Message Tom Lane 2007-07-07 15:44:48 Re: Unable to get postgres running after long time no vacuum