Hi all, I've committed some experimental code to HEAD (not 2.0 of course), which implements message delivery within a transaction.
The code is pretty straightforward. In the beginning of insert_messages, it begins a transaction, and when a database failure occurs, the transaction is rolled back. Otherwise it's committed. The functions db_commit_transaction() and db_rollback_transaction have some extra logic: db_commit_transaction(): If "COMMIT" fails for some reason, execute db_rollback_transaction() and return -1; db_rollback_transaction(): if "ROLLBACK" fails, disconnect from the database and reconnect again. This will implicitely rollback the transaction, won't it? Ilja -- Ilja Booij IC&S B.V. Stadhouderslaan 57 3583 JD Utrecht www.ic-s.nl T algemeen: 030 6355730 T direct: 030 6355739 F: 030 6355731 E: [EMAIL PROTECTED]
