Re: [sqlite] Lock and transaction

2011-11-04 Thread Paxdo Presse
Great. Thanks to both. (and sorry for my bad english) Le 5 nov. 2011 à 00:05, Petite Abeille a écrit : > > On Nov 4, 2011, at 11:59 PM, Paxdo Presse wrote: > >> Are we sure that another process is not going to create another row between >> my "INSERT" and "SELECT LAST ROWID"? > > yes >

Re: [sqlite] Lock and transaction

2011-11-04 Thread Petite Abeille
On Nov 4, 2011, at 11:59 PM, Paxdo Presse wrote: > Are we sure that another process is not going to create another row between > my "INSERT" and "SELECT LAST ROWID"? yes > The "LAST ROWID" is it for sure the id of "INSERT INTO" of the transaction? yes

Re: [sqlite] Lock and transaction

2011-11-04 Thread Richard Hipp
On Fri, Nov 4, 2011 at 6:59 PM, Paxdo Presse wrote: > > Hello, > > a question from beginner please : > > In this transaction (with wal-mode) : > > > BEGIN TRANSACTION > > INSERT INTO > > SELECT last_insert_rowid() > > COMMIT > > > Are we sure that another process is not going

[sqlite] Lock and transaction

2011-11-04 Thread Paxdo Presse
Hello, a question from beginner please : In this transaction (with wal-mode) : BEGIN TRANSACTION INSERT INTO SELECT last_insert_rowid() COMMIT Are we sure that another process is not going to create another row between my "INSERT" and "SELECT LAST ROWID"? The "LAST ROWID" is it for