On Wed, May 25, 2011 at 10:12:42AM +0100, Julian Foad wrote: > We can catch some WC DB inconsistencies as soon as they happen by adding > SQLite "trigger" functions that fire on adding or modifying rows, and > throw an error if some condition is not met. This is especially useful > in the NODES table because of its complex rules. > > This patch is presented as a concept and not to apply as-is. It adds a > couple of very simple checks, with which I caught the bug fixed in > r1127069 and the test-bug fixed in r1127072.
I would very much be in favour of adding such checks by default if svn is compiled in maintainer mode!
