Re: Column level triggers - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Column level triggers
Date
Msg-id 48F5A3F8.4090508@gmx.net
Whole thread Raw
In response to Re: Column level triggers  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: Column level triggers  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Scott Marlowe wrote:
> Since you can check which columns have changed, it's pretty easy to
> write a trigger that just skips its logic when none of the trigger
> columns have changed.

I think column-level triggers actually fire when one of the columns is
written to, not only when the value there is distinct from the previous
one.  This small difference is not easy to emulate by comparing OLD and
NEW in the trigger body.  Details might need to be checked in the
standard and existing implementations.

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: Drupal and PostgreSQL - performance issues?
Next
From: "Laurent Wandrebeck"
Date:
Subject: Re: Column level triggers