Re: minimal update trigger

David Fetter wrote:
> On Tue, Feb 19, 2008 at 09:32:30PM -0500, Andrew Dunstan wrote:
>
>> As discussed a little while back, I would like to add a generic
>> trigger function which will force an update to skip if the new and
>> old tuples are identical.
>>
>
> This one has lots of use cases. Did the earlier discussion settle on
> whether there should be a GUC and/or CREATE DATABASE and/or initdb
> option for this?
>
>

None of the above. All we will be providing is a trigger function. You
would create the trigger as with any other trigger:

| CREATE TRIGGER _min BEFORE UPDATE ON mytable
FOR EACH ROW
EXECUTE PROCEDURE pg_minimal_update();

cheers

andrew
|