Thread: citext in windows.

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.

On Wed, Feb 27, 2008 at 11:11:52AM +1300, Tim Uckun wrote:
> 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.

That is something you need to talk to the citext creators about. Ideally,
they shold provide a stackbuilder compatible binary download 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.

EnterpriseDB is a different product from PostgreSQL. There may be some
moduels that work in both, but don't count on it. For one thing  I think
the latest EDB is based on 8.2, not 8.3. But there could be a lot of other
reasons as well. If you want a module to load in PostgreSQL, it has to be a
PostgreSQL module.


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

I think you need to talk to the citext people. Unless somebody else has
already made a package available somewhere?

//Magnus