On Monday, 12. January 2009 13:52:47 P Kishor wrote:
> > Here's a short example to reproduce the problem:
> >
> > sqlite3 test.db
> > create table test (name varchar(16));
> > begin transaction;
> > insert into test values ('test');
>
> did you forget to COMMIT here?Thanks for your reply. In fact it's the core of the problem: You can't dump a database if there is an open, uncommited transaction. This used to work in 3.5.9 and is needed for creating backups of databases. If an open transaction would block the dump of the database, then the second command line tool should busy wait until a timeout occurs or atleast return an error message. Thomas _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
