Re: [pgsql-hackers-win32] What's left?

> -----Original Message-----
> From: Claudio Natoli [mailto:claudio(dot)natoli(at)memetrics(dot)com]
> Sent: Thursday, January 22, 2004 4:44 PM
> To: 'Andrew Dunstan '; 'pgsql-hackers-win32 ';
> 'PostgreSQL-development '
> Subject: Re: [pgsql-hackers-win32] [HACKERS] What's left?
>
>
>
> Andrew Dunstan wrote:
> > Claudio Natoli wrote:
> >
> > > * installation directory issues (/usr/local/pgsql/bin
> won't work too
> > > well outside of the MingW environment :-)
> >
> >
> > Clearly we will need an installer for a binary distribution.
>
> Yes. To be more precise, my point was that doing so will
> require some changes to the code (ie. configure/compile time
> constants like PKGLIBDIR just won't do us any good).
>
>
> > But for now I suggest that the default prefix on Windows is
> > C:\Program Files\PostgreSQL

More properly:
%ProgramFiles%\PostgreSQL

And then, if they don't like that, let them put it wherever they darn
well please.

> For right now, I'd suggest a directory that doesn't have
> whitespace and localization issues :-P

It will have to be faced. If it cannot handle spaces or funny
characters, it will simply fail.

I may be able to help on the localization and path stuff. We have
solved those issues for our port of 7.1.3, and I expect the work for 7.5
to be extremely similar.

Where can I get the latest tarball for Win32 development?

Dann Corbit wrote:
>>>But for now I suggest that the default prefix on Windows is
>>>C:\Program Files\PostgreSQL
>
> More properly:
> %ProgramFiles%\PostgreSQL

Another suggestion: %ProgramFiles%\PGDG\PostgreSQL (or even
%ProgramFiles%\PGDG\PostgreSQL 7.5). Apache2 uses %ProgramFiles%\Apache
Group\Apache2.

Note: Many software uses the %ProgramFiles%\<VendorName>\<ProductName>
convention, but apparently Microsoft itself puts stuffs right under
%ProgramFiles% (%ProgramFiles%\Microsoft Money, \Internet Explorer,
\Windows Media Player, etc).

> And then, if they don't like that, let them put it wherever they darn
> well please.

--
dave

I think users would prefer %ProgramFiles%\PostgreSQL - that's what Mozilla
and some other projects do, although still other projects do
%ProgramFiles%\GNU\PostgreSQL.

I'd vote for %ProgramFiles%\PostgreSQL.

- Steve

-----Original Message-----
From: pgsql-hackers-win32-owner(at)postgresql(dot)org
[mailto:pgsql-hackers-win32-owner(at)postgresql(dot)org] On Behalf Of David
Garamond
Sent: January 23, 2004 2:42 AM
To: Dann Corbit
Cc: Claudio Natoli; Andrew Dunstan; pgsql-hackers-win32;
PostgreSQL-development
Subject: Re: [pgsql-hackers-win32] [HACKERS] What's left?

Dann Corbit wrote:
>>>But for now I suggest that the default prefix on Windows is
>>>C:\Program Files\PostgreSQL
>
> More properly:
> %ProgramFiles%\PostgreSQL

Another suggestion: %ProgramFiles%\PGDG\PostgreSQL (or even
%ProgramFiles%\PGDG\PostgreSQL 7.5). Apache2 uses %ProgramFiles%\Apache
Group\Apache2.

Note: Many software uses the %ProgramFiles%\<VendorName>\<ProductName>
convention, but apparently Microsoft itself puts stuffs right under
%ProgramFiles% (%ProgramFiles%\Microsoft Money, \Internet Explorer, \Windows
Media Player, etc).

> And then, if they don't like that, let them put it wherever they darn
> well please.

--
dave

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly

Dann Corbit wrote:

>>-----Original Message-----
>>From: Claudio Natoli [mailto:claudio(dot)natoli(at)memetrics(dot)com]
>>Sent: Thursday, January 22, 2004 4:44 PM
>>To: 'Andrew Dunstan '; 'pgsql-hackers-win32 ';
>>'PostgreSQL-development '
>>Subject: Re: [pgsql-hackers-win32] [HACKERS] What's left?
>>
>>
>>
>>Andrew Dunstan wrote:
>>
>>
>>>Claudio Natoli wrote:
>>>
>>>
>>>
>>>>* installation directory issues (/usr/local/pgsql/bin
>>>>
>>>>
>>won't work too
>>
>>
>>>>well outside of the MingW environment :-)
>>>>
>>>>
>>>Clearly we will need an installer for a binary distribution.
>>>
>>>
>>Yes. To be more precise, my point was that doing so will
>>require some changes to the code (ie. configure/compile time
>>constants like PKGLIBDIR just won't do us any good).
>>
>>
>>
>>
>>>But for now I suggest that the default prefix on Windows is
>>>C:\Program Files\PostgreSQL
>>>
>>>
>
>More properly:
>%ProgramFiles%\PostgreSQL
>
>And then, if they don't like that, let them put it wherever they darn
>well please.
>
>
>
>>For right now, I'd suggest a directory that doesn't have
>>whitespace and localization issues :-P
>>
>>
>
>It will have to be faced. If it cannot handle spaces or funny
>characters, it will simply fail.
>
>
What about 8.3 short names for the win32 environment?
"C:\Progra~1\Postgres" Should be able to work correctly. Isn't there a
win32 command to get the short path if you need it?

>I may be able to help on the localization and path stuff. We have
>solved those issues for our port of 7.1.3, and I expect the work for 7.5
>to be extremely similar.
>
>Where can I get the latest tarball for Win32 development?
>
>---------------------------(end of broadcast)---------------------------
>TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
>

Thomas Swan wrote:

>>
>> More properly:
>> %ProgramFiles%\PostgreSQL
>>
>> And then, if they don't like that, let them put it wherever they darn
>> well please.
>>
>>
>>
>>> For right now, I'd suggest a directory that doesn't have whitespace
>>> and localization issues :-P
>>>
>>
>>
>> It will have to be faced. If it cannot handle spaces or funny
>> characters, it will simply fail.
>>
>>
> What about 8.3 short names for the win32 environment?
> "C:\Progra~1\Postgres" Should be able to work correctly. Isn't there
> a win32 command to get the short path if you need it?

Please not... 8.3 is really ancient.
PostgreSQL-win32 should be as native as possible, including all
naming/path/registry conventions. The more familiar pgsql looks to
hardcore windowers, the better will be the acceptance for a newbie.

Regards,
Andreas

Dann Corbit wrote:
> I may be able to help on the localization and path stuff. We have
> solved those issues for our port of 7.1.3, and I expect the work for 7.5
> to be extremely similar.
>
> Where can I get the latest tarball for Win32 development?

CVS HEAD now has all the Win32 work.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

Steve Tibbett wrote:
> I think users would prefer %ProgramFiles%\PostgreSQL - that's what Mozilla
> and some other projects do, although still other projects do
> %ProgramFiles%\GNU\PostgreSQL.

What would be the reason to put PostgreSQL into %ProgramFiles%\GNU ?

Jan

>
> I'd vote for %ProgramFiles%\PostgreSQL.
>
> - Steve
>
>
> -----Original Message-----
> From: pgsql-hackers-win32-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-win32-owner(at)postgresql(dot)org] On Behalf Of David
> Garamond
> Sent: January 23, 2004 2:42 AM
> To: Dann Corbit
> Cc: Claudio Natoli; Andrew Dunstan; pgsql-hackers-win32;
> PostgreSQL-development
> Subject: Re: [pgsql-hackers-win32] [HACKERS] What's left?
>
> Dann Corbit wrote:
>>>>But for now I suggest that the default prefix on Windows is
>>>>C:\Program Files\PostgreSQL
>>
>> More properly:
>> %ProgramFiles%\PostgreSQL
>
> Another suggestion: %ProgramFiles%\PGDG\PostgreSQL (or even
> %ProgramFiles%\PGDG\PostgreSQL 7.5). Apache2 uses %ProgramFiles%\Apache
> Group\Apache2.
>
> Note: Many software uses the %ProgramFiles%\<VendorName>\<ProductName>
> convention, but apparently Microsoft itself puts stuffs right under
> %ProgramFiles% (%ProgramFiles%\Microsoft Money, \Internet Explorer, \Windows
> Media Player, etc).
>
>> And then, if they don't like that, let them put it wherever they darn
>> well please.
>
> --
> dave
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #