chtaylo3 <[EMAIL PROTECTED]> wrote:
> I have a question about os_unix.c
>
> On line 854 inside function sqlite3UnixTempFileName, you declare:
> static const char *azDirs[] = {
> 0,
> "/var/tmp",
> "/usr/tmp",
> "/tmp",
> ".",
> };
>
> I'm guessing this is where sqlite attempts to create a temp copy of the
> database it's opening.
Nope. This is where it puts temporary tables you create
using CREATE TEMP TABLE.
>
> I'm having difficulties with this because I'm running apache & trac (
> http://trac.edgewall.org/ ) as a non-priviliged user (of course) and
> subsequently it does not have read access to either of these directories. Is
> there a chance it could, at runtime, eval the environment variable $TMP and
> use that as one of the options?
>
> It looks like creating the temp file fails if and only if all of the dirs
> listed in azDirs is accessible. So just adding the env var $TMP should solve
> this problem. Do you agree? if so, I'd be happy to write a patch for this.
>
Set the global variable sqlite3_temp_directory to any
directory you want and it tries that directory first.
--
D. Richard Hipp <[EMAIL PROTECTED]>
