big advance for replication - if the record could update itself using rules...

creating rule like such:

mydb => create rule updtimeset as on update to mytab do update mytab set updtime = current_time ;

causes this:

mydb=> update mytab set updtime = current_time;
ERROR: query rewritten 10 times, may contain cycles

offcourse.

however, it vould be great to have possibility to do something like that.

Yes, i could use triggers, however such solution is not so clear as the rule-method could be...

or do somebody know about ... ?

--
dan peder
dpeder(at)infoset(dot)cz