Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 30B509FB231 for ; Mon, 12 Feb 2007 05:35:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 63848-04 for ; Mon, 12 Feb 2007 05:35:00 -0400 (AST) X-Greylist: whitelisted by SQLgrey-1.7.4 Received: from mail08.syd.optusnet.com.au (mail08.syd.optusnet.com.au [211.29.132.189]) by postgresql.org (Postfix) with ESMTP id B042D9FB2BA for ; Mon, 12 Feb 2007 05:35:07 -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 mail08.syd.optusnet.com.au (8.13.1/8.13.1) with ESMTP id l1C9YuA9013627; Mon, 12 Feb 2007 20:34:59 +1100 Message-ID: <45D034E7.6010804@autoledgers.com.au> Date: Mon, 12 Feb 2007 18:35:35 +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> In-Reply-To: <20070212085659.GD4432@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 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200702/9 X-Sequence-Number: 2532 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > > 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. 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. -- Paul Lambert Database Administrator AutoLedgers