I think the problem is with the \ (Note direction) as this makes the next character a literal character. So it isn't trying to drop the file into a sub directory, its using a literal character e. So
/var/tmp/etilqs_PIREaghry4bPE*S8\et*ilqs_02LTi9u3HO3cx0g translates to /var/tmp/etilqs_PIREaghry4bPE*S8et*ilqs_02LTi9u3HO3cx0g as far as the OS is concerned. But something is messing with SQLites head because of that. SQLite might be trying to open the file changing the \ to \\ which means literal \ which ends up being NOT the same filename I've NOT looked at source code to validate my statement. This is 100% theory. On Tue, Jun 4, 2013 at 12:13 PM, Richard Hipp <d...@sqlite.org> wrote: > On Tue, Jun 4, 2013 at 11:59 AM, Philip Goetz <philgo...@gmail.com> wrote: > > > On Tue, Jun 4, 2013 at 11:27 AM, Richard Hipp <d...@sqlite.org> wrote: > > > Try adding the command: > > > > > > .log stdout > > > > > > before running the CREATE INDEX and see what errors you get back. > > > > sqlite> .schema > > CREATE TABLE taxon (gi INTEGER, taxon INTEGER); > > sqlite> .log stdout > > sqlite> create index taxon_gi_index on taxon(gi); > > (14) os_win.c:34063: (3) > > winOpen(/var/tmp/etilqs_PIREaghry4bPES8\etilqs_02LTi9u3HO3cx0g) - The > > system cannot find the path specified. > > (14) cannot open file at line 34071 of [cbea02d938] > > (14) statement aborts at 21: [create index taxon_gi_index on taxon(gi);] > > Error: unable to open database file > > > > Not finding paths often has to do with windows vs. unix vs. cygwin > > file specifications. The above was running sqlite from the cygwin > > command prompt. > > But running it from the MS DOS command prompt with > > E:\data\db\SQLite>C:/bin/os/cygwin/bin/sqlite3 gi2taxonNt > > gives almost the same error (just a different /var/tmp filename). > > I have write permission on /var/tmp and can make files in it. > > > > But apparently it is trying to create a file in a subdirectory. I don't > quite understand that. > > -- > D. Richard Hipp > d...@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