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
|
- Re: [GENERAL] Update rule Secrétariat
- Re: [GENERAL] Update rule Pierre-Frédéric Caillaud
- Re: [GENERAL] Update rule Secrétariat