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.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

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.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

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...2/msg00844.php
http://lists.pgfoundry.org/pipermail...ry/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


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

> 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?

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

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



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend