Tom Lane wrote:
>John R Pierce <pierce@hogranch.com> writes:
>
>
>>more fun. I just checked the environment of the postmaster service on a
>>win2000 Pro system (using www.sysinternals.com's excellent Process Explorer
>>tool, btw). HOME is not set. USERPROFILE is set to "C:\Documents and
>>Settings\postgres"...
>>
>>
>Actually, the server doesn't depend on home directories in any way shape
>or form. The places that we are concerned about are on the client side,
>either in libpq or in psql. So what we have to think about is the
>environment that libpq might see.
>
Right but I think the point is that the environment variable HOME does
not exist on windows. At least I have never seen it. I think it does
exist inside CYGWIN (perhaps in mingw also?) might the use of the HOME
variable be related to the Cygwin port?
The standard env variables relevant to this conversation are the two I
mentioned before (HOMEDRIVE, HOMEPATH) and the one mentioned above
(USERPROFILE) which seems to be equivalent to HOMEDRIVE and HOMEPATH
concatenated together.
Matthew