Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 686309FB514 for ; Mon, 12 Feb 2007 06:08:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 91693-02 for ; Mon, 12 Feb 2007 06:08:46 -0400 (AST) X-Greylist: whitelisted by SQLgrey-1.7.4 Received: from mail33.syd.optusnet.com.au (mail33.syd.optusnet.com.au [211.29.132.104]) by postgresql.org (Postfix) with ESMTP id 7192E9FB2C7 for ; Mon, 12 Feb 2007 06:08:45 -0400 (AST) Received: from [220.238.209.141] (d220-238-209-141.dsl.vic.optusnet.com.au [220.238.209.141]) (authenticated sender plengada) by mail33.syd.optusnet.com.au (8.13.1/8.13.1) with ESMTP id l1CA8N5O008360; Mon, 12 Feb 2007 21:08:31 +1100 Message-ID: <45D03CBE.7030606@autoledgers.com.au> Date: Mon, 12 Feb 2007 19:09:02 +0900 From: Paul Lambert User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: Magnus Hagander CC: pgsql-ports@postgresql.org Subject: Re: Windows installation suggestion References: <45CFDB6D.3060502@autoledgers.com.au> <20070212085659.GD4432@svr2.hagander.net> <45D034E7.6010804@autoledgers.com.au> <20070212095735.GH4432@svr2.hagander.net> In-Reply-To: <20070212095735.GH4432@svr2.hagander.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL, BAYES_50 X-Spam-Level: X-Archive-Number: 200702/11 X-Sequence-Number: 2534 Magnus Hagander wrote: > On Mon, Feb 12, 2007 at 06:35:35PM +0900, Paul Lambert wrote: >> Magnus Hagander wrote: >>> On Mon, Feb 12, 2007 at 12:13:49PM +0900, Paul Lambert wrote: >>>> I'd like to make a suggestion for a change to the windows installation >>>> for Postgres if permissable... not sure if this is the right list to be >>>> posting to. >>>> >>>> Suggestion as follows: >>>> >>>> Have the install update the PATH environment variable to include the >>>> Postgres BIN directory to enable things to be run from commandline (such >>>> as psql) without having to switch into that directory. >>> We've talked about this before, and rejected it. The reason is that it >>> breaks when you have more than one version installed on the same system. >>> >>> We've considered adding a checkbox (off by default) to the installation >>> that would set it, though, but the demand just hasn't been there yet ;-) >>> >>> Does it not help to just use the "Command Prompt" shortcut on the >>> PostgreSQL menu in the start menu? >>> >>> //Magnus >>> >> I'm setting up some batch jobs that perform various tasks, some of which >> will involve psql. I've manually adjusted the path variable on my server >> in this instance, however I can see that multiple versions may result in >> some undesired behavior. >> >> A checkbox would work, providing it removes the pre-existing >> installations reference in the path variable... otherwise you could be >> unknowingly running the wrong version of programs and seeing unexpected >> results. > > That is the problem - how to find and identify that one, and how to be > sure that it was something added by the installer and not by the user > himself. So far we've just taken the easy way out and said the user has > to deal with it. > Logical way out I'd say. >> Apparently this fact didn't cross my mind when I decided to make the >> suggestion ;) >> >> I blame my ignorance on years of using M$ SQL server. > > Yeah, they don't support multiple versions on the same machine :-) Lack > of features makes some thigns easier :-) > Easier - perhaps, more frustrating - definitely. > //Magnus > Cheers for the info. P. -- Paul Lambert Database Administrator AutoLedgers