citext in windows.

From: "Tim Uckun" <timuckun(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: citext in windows.
Date: 2008-02-26 22:11:52
Message-ID: 855e4dcf0802261411w1fa55053j2f383928578fd4a0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I just downloaded postgres 8.3 for windows and noticed that citext is
not an option for columns.

The web site has the source code but no binaries for windows.

I downloaded the enterprisedb and noticed that it has the citext.dll
in the lib directory so I copied the dll over to the postgres lib
directory and tried to run the sql to install the type buy no joy.
Postgres complains it can't load the DLL. I triple checked it and it's
in the proper place.

What do I have to do in order to get citext to work on windows?

BTW I just asked on the IRC channel and people suggested I use tolower
or similar tactics. This is just not possible for me. In this case I
really need a case insensitive text field.

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-02-26 23:24:08 Re: v7.4 pg_dump(all) need to encode from SQL_ASCII to UTF8
Previous Message Dean Gibson (DB Administrator) 2008-02-26 21:55:56 Re: utf8 issue