Re: [sqlite] Bug: on opening the same database twice

2013-06-26 Thread Israel Lins Albuquerque
Ok, Then let me explain my problem to see if I done the best solution! I have an replication system using sqlite where: - I have 2 databases: one for output* and other for input*; - I have 2 process accessing booth: The first is the replicator: - Get the data on server and write on input

Re: [sqlite] Bug: on opening the same database twice

2013-06-26 Thread Richard Hipp
On Wed, Jun 26, 2013 at 1:24 PM, Israel Lins Albuquerque < israelin...@yahoo.com.br> wrote: > I open an database twice times in same process and same thread one in > readonly mode, and the other read write. > With shared_cache enable. > Opening first the readonly mode and after readwrite mode,

[sqlite] Bug: on opening the same database twice

2013-06-26 Thread Israel Lins Albuquerque
I open an database twice times in same process and same thread one in readonly mode, and the other read write. With shared_cache enable. Opening first the readonly mode and after readwrite mode, the second connection works as read only too. Then I looked to sqlite code and I see the problem in: