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: sqlite3BtreeOpen line 1788, because the shared cache uses the same structure in booth connections, and pBt->pPager->readOnly is set to 1. To workaround this I will open read write mode first, but that make readonly connection become read write. There is an know issue? Regards, -- Israel Lins Albuquerque Antes de imprimir, pense em sua responsabilidade com o MEIO AMBIENTE. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
