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

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

pgsql-bugs by date:

Previous
From: Hartmut Goebel
Date:
Subject: Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #5364: citext behavior when type not in public schema