On Tue, Feb 19, 2013 at 6:37 PM, Choi, David <david.c...@micrel.com> wrote:
> Hi Richard, > > It seems that my version is not accept the command. By the way, what is > the version that you are referring to? > Get the latest: 3.7.15.1. There is no reason not to. > > Here is my operation: > /home # sqlite3 --help > Usage: sqlite3 [OPTIONS] FILENAME [SQL] > FILENAME is the name of an SQLite database. A new database is created > if the file does not previously exist. > OPTIONS include: > -help show this message > -init filename read/process named file > -echo print commands before execution > -[no]header turn headers on or off > -bail stop after hitting an error > -interactive force interactive I/O > -batch force batch I/O > -column set output mode to 'column' > -csv set output mode to 'csv' > -html set output mode to HTML > -line set output mode to 'line' > -list set output mode to 'list' > -separator 'x' set output field separator (|) > -nullvalue 'text' set text string for NULL values > -version show SQLite version > /home # sqlite3 -version > 3.6.23.1 > /home # sqlite3 -vfs unix-none ex1 > sqlite3: Error: unknown option: -vfs > Use -help for a list of options. > > > Regards, > David J. Choi > > > -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto: > sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp > Sent: Tuesday, February 19, 2013 1:44 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] database is locked with create > > On Tue, Feb 19, 2013 at 4:39 PM, Choi, David <david.c...@micrel.com> > wrote: > > > Hi Richard, > > > > I think your guess is highly possible because the error comes from > > sqliteErrorFromPosixError(). In that case, how can I fix the issue? > > > > Try adding the -vfs unix-none command-line option: > > sqlite3 -vfs unix-none ex1 > > That will disable file locking. Be warned, however, that with file > locking disabled, two processes trying to access the database at the same > time can lead to problems.-- D. Richard Hipp > drh@sqlite.org_______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users