Jonathan Feally wrote: > The constraints are set such that the dbmail_phymessage row would need > to be deleted to cascade a delete in the dbmail_messageblks. So simply > inserting the unique parts in the mimeparts, then insert the part_id's > into partlists, update header cache, then delete the messageblks. All > sounds simple enough. Essentially a retrieve piped to insert loop.
Jon, there's no need to update the header cache. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev