On Fri, Mar 5, 2010 at 5:24 AM, Markus Wichitill <ma...@gmx.de> wrote: > > The following bug has been logged online: > > Bug reference: 5364 > Logged by: Markus Wichitill > Email address: ma...@gmx.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs