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

2010-06-03 Thread Bruce Momjian
Markus Wichitill wrote: > On 03.06.2010 05:05, Bruce Momjian wrote: > > The schema containing the citext operators must be > > in the current search_path (typically 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 c

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

2010-06-03 Thread Markus Wichitill
On 03.06.2010 05:05, Bruce Momjian wrote: > The schema containing the citext operators must be > in the current search_path (typically 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. "pu

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

2010-06-03 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > I have documented this citext limitation with the attached, applied > > patch. > > Are you planning to insert similar verbiage into every other contrib > module's docs? Uh, do they all have this odd behavior? Most people assume they would get an error

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

2010-06-02 Thread Tom Lane
Bruce Momjian writes: > I have documented this citext limitation with the attached, applied > patch. Are you planning to insert similar verbiage into every other contrib module's docs? regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To

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

2010-06-02 Thread Bruce Momjian
Robert Haas wrote: > On Fri, Mar 5, 2010 at 5:24 AM, Markus Wichitill wrote: > > > > The following bug has been logged online: > > > > Bug reference: ? ? ?5364 > > Logged by: ? ? ? ? ?Markus Wichitill > > Email address: ? ? ?ma...@gmx.de > > PostgreSQL version: 8.4.2 > > Operating system: ? Linux,

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

2010-03-12 Thread Robert Haas
On Fri, Mar 5, 2010 at 5:24 AM, Markus Wichitill wrote: > > The following bug has been logged online: > > Bug reference:      5364 > Logged by:          Markus Wichitill > Email address:      ma...@gmx.de > PostgreSQL version: 8.4.2 > Operating system:   Linux, Win7 > Description:        citext be

[BUGS] BUG #5364: citext behavior when type not in public schema

2010-03-05 Thread Markus Wichitill
The following bug has been logged online: Bug reference: 5364 Logged by: Markus Wichitill Email address: ma...@gmx.de PostgreSQL version: 8.4.2 Operating system: Linux, Win7 Description:citext behavior when type not in public schema Details: Comparisons with columns