Tom Allison wrote: > Paul J Stevens wrote: >> Tom Allison wrote: >>> When deleting email, I noticed a lot of commands go in pairs of >>> >>> Debug:[sql] dbpgsql.c,db_query(+279): [SELECT message_idnr FROM >>> dbmail_messages WHERE physmessage_id = 123314] >>> Debug:[sql] dbpgsql.c,db_query(+279): [DELETE FROM dbmail_physmessage >>> WHERE id = 123314] >>> Debug:[sql] dbpgsql.c,db_query(+279): [DELETE FROM dbmail_messageblks >>> WHERE physmessage_id = 123314] >>> >>> >>> Could this be done better with the use of referential integrity >>> constraints to ensure that the data isn't lost or "disconnected" ? >> >> Referential integrity is used throughout the dbmail schema. >> >> Above 'redundancy' is legacy code from dbmail's mysql/myisam past - >> which is in fact deprecated and unsupported in 2.2. Those extra queries >> will be removed from dbmail. >> >> >> > > OK, so this is just something I'm going to see because I'm deep in the > throws of 'RC'?
No, they won't be removed before 2.2.0-final. They will be removed during the 2.2 cycle though. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
