Re: Update rule

Many thanks for your explanation.
I found in the contrib the function moddatetime
CREATE TRIGGER dmodtar_upd
BEFORE UPDATE ON tarifs
FOR EACH ROW
EXECUTE PROCEDURE public.moddatetime(dmodtar) ;
So all works fine !
PostgreSQL 8 is great.

----- Original Message -----
From: "Pierre-Frédéric Caillaud" <lists(at)boutiquenumerique(dot)com>
To: "Secrétariat" <ets(at)rolland-fr(dot)com>; <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, December 30, 2004 7:08 PM
Subject: Re: [GENERAL] Update rule

>
> You get infinite recursion because your ON UPDATE rule does another
> UPDATE which of course calls the rule ; so no, it's not a bug ; also your
> UPDATE updates almost the whole table so it won't do what you had in mind
> in the first place. You should rather change the NEW row in your update so
> that NEW.dmodtar = current_date and NEW.umodtar = current_user. Which
> means you'll rather be using a trigger for this. Read the docs on CREATE
> TRIGGER and see the examples, I think there's one which looks like what
> you want.
>
>
>> Hello !
>>
>> I wish to create a rule to write in records who and when modified them.
>> I wrote :
>> CREATE OR REPLACE RULE tarif_upd AS
>> ON UPDATE TO tarifs
>> DO ALSO
>> UPDATE tarifs
>> SET dmodtar = current_date, umodtar = current_user
>> WHERE dmodtar <> current_date AND umodtar <> current_user ;
>> But I obtain an infinite recursion !
>> It seems not using the where clause ?
>> Is it a bug ?
>> How can I workaround ...
>>
>> Best regards.
>> Luc
>
>
>