Skip site navigation (1) Skip section navigation (2)

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

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Markus Wichitill <mawic(at)gmx(dot)de>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5364: citext behavior when type not in public schema
Date: 2010-03-12 16:21:43
Message-ID: 603c8f071003120821s48568846la4be4d7cace9456c@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2010-03-12 16:26:36
Subject: Re: Cannot create UTF-8 database
Previous:From: Robert HaasDate: 2010-03-12 16:20:01
Subject: Re: BUG #5371: Error 193: 0xc1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group