Question : I went overboard on CITEXT columns on a particularly large table in my application. I would like to […]
Tag: citext
Where do you find the citext module in postgres 9.3 on ubuntu 14.04?
Question : So I’m trying to use citext, but it appears to be MIA from ubuntu 14.04 postgres install. Where […]
How do I resolve Postgresql error, ‘no collation was derived for column “foo” with collatable type citext’?
Question : Just recently I upgraded from Postgresql 8.4.11 to 9.1.3. I used pg_dump in the process. Now I’m getting […]
Why does a comparison between CITEXT and TEXT fail?
Question : As expected, when doing an equality test like this, the comparison succeeds: CREATE TABLE citext_test ( value citext […]