Recursion

Beatnik on 2006-08-24T11:29:20

So I had one of those database triggers.. matching a specific column, it would generate a new row based on the match. What I didn't really think about was that I was recycling data and that the new row would also be matched by the trigger rule. That, in turn, another new row would be generated based on generated row. Fortunatly, there's row correlation (compressing a large number of similar rows into one row that says it all) and long trigger intervals (only matching rows every X minutes).

All is well now, in database land!