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

2010-06-03 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian br...@momjian.us 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

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 typecitext/ operators must be in the current varnamesearch_path/ (typically literalpublic/); 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

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 typecitext/ operators must be in the current varnamesearch_path/ (typically literalpublic/); It's been a while, but the way I read my own example is that the schema containing the citext operators

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 ma...@gmx.de 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-06-02 Thread Tom Lane
Bruce Momjian br...@momjian.us 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

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 ma...@gmx.de 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:        

[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