> > Wouldn't a single physmessage_id entry be enough in dbmail_datefield? If > > yes, the index dbmail_datefield_1, which currently is UNIQUE > > (physmessage_id, id) could be changed to UNIQUE (physmessage_id).
This is interesting. I'm using MySQL here and the UNIQUE is keyed off the physmessage_id and the datefield. So when I see this problem I get errors inserting the date due to the duplicate. Again, I get this repeatedly as the real problem (in this case missing headers - from, to, subject etc) is not repaired due to it halting on the first error. Maybe the INSERT INTO here can be a REPLACE INTO to avoid duplicates, otherwise ignore any duplicate errors as obviously that particular header already exists. Regards, Josh. _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
