Thread: UUID-OSSP for windows.

UUID-OSSP for windows.

From
"Tim Uckun"
Date:
Where can I get uuid-ossp for windows?  Also where can I get citext for windows.

These two are missing from the windows installer.

Thanks.

Re: UUID-OSSP for windows.

From
"Scott Marlowe"
Date:
On Tue, Feb 26, 2008 at 9:44 PM, Tim Uckun <timuckun@gmail.com> wrote:
> Where can I get uuid-ossp for windows?  Also where can I get citext for windows.
>
>  These two are missing from the windows installer.

Search the archives.  There was a conversation about this in the last
week or two.  Basically, windows has it's own uuid, and there's a
discussion on how to exploit that instead of importing uuid-ossp.

Re: UUID-OSSP for windows.

From
"Hiroshi Saito"
Date:
Hi.

----- Original Message -----
From: "Scott Marlowe" <scott.marlowe@gmail.com>


> On Tue, Feb 26, 2008 at 9:44 PM, Tim Uckun <timuckun@gmail.com> wrote:
>> Where can I get uuid-ossp for windows?  Also where can I get citext for windows.
>>
>>  These two are missing from the windows installer.
>
> Search the archives.  There was a conversation about this in the last
> week or two.  Basically, windows has it's own uuid, and there's a
> discussion on how to exploit that instead of importing uuid-ossp.

I enabled it to offer it after the joint work of one time with Mr. Ralf S.Engelschall.
http://archives.postgresql.org/pgsql-hackers/2008-02/msg00844.php
http://lists.pgfoundry.org/pipermail/pginstaller-devel/2008-February/001056.html

PostgreSQL is required for compile.(It is not regular.)
http://winpg.jp/~saito/pg_work/OSSP_win32/msvc/
However, It is publicly released as MinGW+GCC.
http://winpg.jp/~saito/pg_work/OSSP_win32/

Then, It is now exposed to verification.
I want to include in the next release.
Thanks!

Regards,
Hiroshi Saito


Re: UUID-OSSP for windows.

From
"Dave Page"
Date:
On Wed, Feb 27, 2008 at 3:44 AM, Tim Uckun <timuckun@gmail.com> wrote:
> Where can I get uuid-ossp for windows?  Also where can I get citext for windows.
>
>  These two are missing from the windows installer.

uuid-ossp is missing because until a few days ago the underlying
uuid-ossp wasn't ported to Windows.

citext is not part of core PostgreSQL or something we have any
intention to include in the Windows distribution at this time.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The HOT PostgreSQL Company

Re: UUID-OSSP for windows.

From
"Tim Uckun"
Date:
>  citext is not part of core PostgreSQL or something we have any
>  intention to include in the Windows distribution at this time.

Is there an alternative for people wanting a case insensitive collation?

Re: UUID-OSSP for windows.

From
Michael Glaesemann
Date:
On Feb 27, 2008, at 16:59 , Tim Uckun wrote:

>>  citext is not part of core PostgreSQL or something we have any
>>  intention to include in the Windows distribution at this time.
>
> Is there an alternative for people wanting a case insensitive
> collation?

ORDER BY lower(foo) ?

Michael Glaesemann
grzm seespotcode net