Re: 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