Piotr Wadas wrote: > >>> Garbage collection on dbmail_mimeparts is still missing. > > Shall I expect the same behaviour, no matter what kind of backend > (mysql/pgsql/sqlite) I'll use? > > Any simple sql hint to cleanup this table manually, something like > > delete > from dbmail_mimeparts > where > message_id > is not in ( select message_idnr from dbmail_messages )
more like: delete from dmail_mimeparts where id not in (select part_id from dbmail_partlists) though this is of course a very slow query. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail