From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
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-06-03 15:25:45 |
Message-ID: | 201006031525.o53FPjt22549@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ None of us is going to be here forever. +
From | Date | Subject | |
---|---|---|---|
Next Message | Hartmut Goebel | 2010-06-03 16:04:16 | Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading |
Previous Message | Markus Wichitill | 2010-06-03 15:23:28 | Re: BUG #5364: citext behavior when type not in public schema |