Hi Leandro,
there is already a good solution for this:
http://www.gossamer-threads.com/lists/dbmail/users/31530#31530
But I think Paul has other things to develop, may you could write the code
that do this?
bye
HArald
Am 15.05.2012, 17:08 Uhr, schrieb leandro <lean...@texnet.it>:
Hello,
am I wrong or there is no dbmail-util procedure to delete headervalues
no more connected to messages?
After deleting some users directly from the dbmail_database and running
the dbmail-util -ay housekeeping utility, I noticed the
dbmail_headervalue table size remains pretty the same.
If I run manually the query:
select count(*) from dbmail_headervalue where id not in ( select
headervalue_id from dbmail_header );
I discovered a large number of no more connected header values.
Almost the same if I check the headernames with the query:
select count(*) from dbmail_headername where id not in ( select
headername_id from dbmail_header );
Leandro
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
