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'?
