I have two databases, db1 and db2. At some point I attach db2 to db1 as 'destdb' then I do:
sqlite3_exec(db1, "BEGIN", ...); sqlite3_exec(db1, "INSERT INTO destdb.table1 SELECT * FROM main.table1", ...); sqlite3_exec(db1, "INSERT INTO destdb.table2 SELECT * FROM main.table2", ...); sqlite3_exec(db1, "COMMIT", ...); so, I am actually reading from db1 and writing to db2, but since the two db are attached and the transaction is started in db1, I wonder if locking on db1 is marked as RESERVED or EXCLUSIVE at some point. (I just would like to know if db1 seems a db with write operations from sqlite's point of view)... and should the transaction be started on db2 or it doesn't matter when the two dbs are attached? Thanks a lot for the clarifications. -- Marco Bambini _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
