On Thu, Jul 25, 2013 at 06:40:32PM +0200, David E. Wheeler wrote: > I’m tempted to add this: > > CREATE UNIQUE INDEX syncrun_sync ON syncrun(sync) WHERE ended IS NULL; > > To both prevent bogus rows in the future, and to help figure out what is > happening should it happen again in the future. > > Should something like this go into the release schema?
Yes. > Ought we to consider adding other constraints to the database? Probably. If for no other reason than to catch stuff like this quicker. The syncrun table is one of the few internal tables that can get quite large, but a single partial index like that should still be no problem. -- Greg Sabino Mullane [email protected] End Point Corporation PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
