On 12/27/12 4:39 PM, Warren Young wrote: > 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.
It's a shame that non-Administrator scenarios get so little attention in general. > 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. Yep: there was recently a long thread on the Cygwin mailing list about which mode to use for the official sqlite3 package: in the end, avoidance of database corruption when interoperating with pure Windows won over the benefits of "Unix mode", so we'll be shipping a "Windows mode" sqlite library to users. Personally, I think using "Windows mode" is the right call. Still, "Windows mode" SQLite should try to work properly in a Cygwin environment. I hope you'll be able to fix this bug.
signature.asc
Description: OpenPGP digital signature
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
