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