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

From: Markus Wichitill <mawic(at)gmx(dot)de>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5364: citext behavior when type not in public schema
Date: 2010-06-03 15:23:28
Message-ID: 4C07C8F0.1060108@gmx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 03.06.2010 05:05, Bruce Momjian wrote:
> The schema containing the <type>citext</> operators must be
> in the current <varname>search_path</> (typically <literal>public</>);

It's been a while, but the way I read my own example is that the schema
containing the citext operators being in the current search_path isn't
enough. "public" must be in the search_path, too, even if it's not
really involved.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2010-06-03 15:25:45 Re: BUG #5364: citext behavior when type not in public schema
Previous Message Bruce Momjian 2010-06-03 14:40:47 Re: BUG #5469: regexp_matches() has poor behaviour and more poor documentation