On 12/26/2012 22:19, Daniel Colascione wrote:
The reason this operation fails is that SQLite cannot create a
temporary file in "C:\Windows",
...unless you run as Admin, which is why you don't hear this complaint
come up more often.
Thanks for diagnosing this in any case. It's clarified some details of
what's going on for me.
In a Cygwin environment, SQLite should avoid GetTempPathW and instead
use unixGetTempname to find the temporary directory, translating paths
as appropriate.
Actually, you *can* get SQLite to do that. There are two ways to build
SQLite under Cygwin, which I call "Windows mode" and "Unix mode". The
current Cygwin SQLite package builds it in Windows mode so that Cygwin
programs linked to it can interoperate with native Windows programs also
using SQLite.
If you rebuild SQLite in Unix mode, I think your immediate problem will
be solved, but you might buy yourself a new problem along these lines:
http://stackoverflow.com/questions/11007024/#11887905
As indicated in that answer, until Cygwin gets a method for selecting
mandatory locking, the official Cygwin SQLite package will continue to
be built in Windows mode.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
