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. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
