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