On 3/15/2012 2:14 PM, Achim Gratz wrote: > René Berber <r.ber...@computer.org> writes: >> The obvious question: what is your $TMP ? > > Obvious maybe — but TMP doesn't get invoked. :-) > > SQLite tries to create the file in the current working directory. > Again, if I do that from a windows console window, all is well, if I do > it from mintty I get an access denied error.
Right. Problem is I can't reproduce the error. I'm not using a snapshot, I'm at "1.7.11(0.260/5/3) 2012-02-24", and the operation you show, using mintty: $ sqlite3 test SQLite version 3.7.3 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .databases seq name file --- --------------- -------------------------------------- 0 main C:\Cygwin\home\rberber\test sqlite> create TEMP TABLE two ( ...> id INTEGER NOT NULL, ...> name CHAR (64) NOT NULL ...> ); sqlite> .databases seq name file --- --------------- --------------------------------------- 0 main C:\Cygwin\home\rberber\test 1 temp sqlite> .schema two CREATE TABLE two ( id INTEGER NOT NULL, name CHAR (64) NOT NULL ); No access denied. The file test is created in the same directory, also .sqlite_history . -- René Berber -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
