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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
