pg.ddx.io  pgsql-ports@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Paul Lambert <paul.lambert@autoledgers.com.au>
To: Magnus Hagander <magnus@hagander.net>
Cc: pgsql-ports@postgresql.org
Subject: Re: Windows installation suggestion
Date: Mon, 12 Feb 2007 19:09:02 +0900
Message-ID: <45D03CBE.7030606@autoledgers.com.au> (raw)
In-Reply-To: <20070212095735.GH4432@svr2.hagander.net>
References: <45CFDB6D.3060502@autoledgers.com.au>
	<20070212085659.GD4432@svr2.hagander.net>
	<45D034E7.6010804@autoledgers.com.au>
	<20070212095735.GH4432@svr2.hagander.net>

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



view thread (5+ messages)

Message-ID: <45D03CBE.7030606@autoledgers.com.au>
Permalink:  ../45D03CBE.7030606@autoledgers.com.au/
Also on:    postgresql.org/message-id/45D03CBE.7030606@autoledgers.com.au

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-ports@postgresql.org
  Cc: paul.lambert@autoledgers.com.au, magnus@hagander.net
  Subject: Re: Windows installation suggestion
  In-Reply-To: <45D03CBE.7030606@autoledgers.com.au>
  References: <45CFDB6D.3060502@autoledgers.com.au> <20070212085659.GD4432@svr2.hagander.net> <45D034E7.6010804@autoledgers.com.au> <20070212095735.GH4432@svr2.hagander.net> <45D03CBE.7030606@autoledgers.com.au>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox