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

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

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 (view raw or flat)
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. +

In response to

pgsql-bugs by date

Next:From: Hartmut GoebelDate: 2010-06-03 16:04:16
Subject: Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading
Previous:From: Markus WichitillDate: 2010-06-03 15:23:28
Subject: Re: BUG #5364: citext behavior when type not in public schema

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