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

On Fri, Mar 5, 2010 at 5:24 AM, Markus Wichitill <mawic@gmx.de> wrote:
>
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A05364
> Logged by: =A0 =A0 =A0 =A0 =A0Markus Wichitill
> Email address: =A0 =A0 =A0mawic@gmx.de
> PostgreSQL version: 8.4.2
> Operating system: =A0 Linux, Win7
> Description: =A0 =A0 =A0 =A0citext 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