Title: problem with Repairing DBMAIL headervalues integrity


hello,


dbmail-util comes to this stage and stops.

I manually run the query:
SELECT hv.id FROM dbmail_headervalue hv LEFT JOIN dbmail_header h ON hv.id = h.headervalue_id WHERE h.headervalue_id IS NULL
 and he returned more than 300,000 lines.

correctly that it is possible to delete all rows from dbmail_headervalue do not have relation to dbmail_header?

I think that one transaction it will be faster than the dbmail-util.


--
С уважением,
Maxim                          
mailto:max_c...@e-foto.ru
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Reply via email to