Re: BUG #5364: citext behavior when type not in public schema

On Fri, Mar 5, 2010 at 5:24 AM, Markus Wichitill <mawic(at)gmx(dot)de> wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5364
> Logged by:          Markus Wichitill
> Email address:      mawic(at)gmx(dot)de
> PostgreSQL version: 8.4.2
> Operating system:   Linux, Win7
> Description:        citext behavior when type not in public schema
> Details:
>
> Comparisons with columns of type citext silently work case-sensitively
> without any error message, unless the search_path contains "public", even if
> the type is not located in "public", but in the same schema as the table
> using it.

Interestingly we recently got another report of this same problem.
Tom did some analysis of it here:

http://archives.postgresql.org/pgsql-bugs/2010-03/msg00017.php

...Robert