-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Tito Ciuro Sent: Wednesday, February 25, 2009 6:36 PM To: sqlite-users@sqlite.org Subject: [sqlite] Transactions and attached databases
Hello, If I attach one or more databases and wrap a series of operations which affect some/all of them, would ROLLBACK or COMMIT treat these operations atomically? For example: Open database 'foo'; Attach database 'bar' as a1; BEGIN TRANSACTION; INSERT INTO main.some_table ... ; DELETE FROM main.some_table WHERE ... ; INSERT INTO a1.another_table ... ; COMMIT/ROLLBACK TRANSACTION; Would the insertions and deletions be either committed or rolled back atomically? Is this supported? Thanks, -- Tito =================== =================== Greetings, Tito, Did you see page: http://www.sqlite.org/lang_attach.html Transactions involving multiple attached databases are atomic, assuming that the main database is not ":memory:". It then goes on to say: If the main database is ":memory:" then transactions continue to be atomic within each individual database file. But if the host computer crashes in the middle of a COMMIT where two or more database files are updated, some of those files might get the changes where others might not. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users