Re: BUG #5364: citext behavior when type not in public schema - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: BUG #5364: citext behavior when type not in public schema
Date
Msg-id 201006031525.o53FPjt22549@momjian.us
Whole thread Raw
In response to Re: BUG #5364: citext behavior when type not in public schema  (Markus Wichitill <mawic@gmx.de>)
List pgsql-bugs
Markus Wichitill wrote:
> 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.

Uh, that doesn't make any sense because there is nothing special about
'public'.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + None of us is going to be here forever. +

pgsql-bugs by date:

Previous
From: Markus Wichitill
Date:
Subject: Re: BUG #5364: citext behavior when type not in public schema
Next
From: Gurjeet Singh
Date:
Subject: superuser unable to modify settings of a system table