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

Re: LIKE predicate and ERROR: 42P22: could not determine which collation to use for string comparison - HINT: Use the COLLATE clause ...

From: John Lumby <johnlumby(at)hotmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: LIKE predicate and ERROR: 42P22: could not determine which collation to use for string comparison - HINT: Use the COLLATE clause ...
Date: 2011-12-13 21:30:47
Message-ID: COL116-W34A35DA9B07B4CA91C8F57A3BD0@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-bugs
(Horribly red face)

All my fault.    It turns out I had applied a source-code change for some additional dtracing which I had merged forward from an older version but which was incorrect in V9.    After removing that it works fine.

Really sorry about that ....

John Lumby

----------------------------------------
> To: johnlumby(at)hotmail(dot)com
> CC: pgsql-bugs(at)postgresql(dot)org
> Subject: Re: [BUGS] LIKE predicate and ERROR: 42P22: could not determine which collation to use for string comparison - HINT: Use the COLLATE clause ...
> Date: Tue, 13 Dec 2011 14:04:02 -0500
> From: tgl(at)sss(dot)pgh(dot)pa(dot)us
>
> John Lumby <johnlumby(at)hotmail(dot)com> writes:
> > I do have other databases in my cluster which probably explains the different datlastsysoid.
>
> No, it wouldn't. datlastsysoid only counts objects created during
> initdb.
>
> [ thinks for a bit ] The most likely explanation for the different
> datlastsysoid value is that the number of pre-created pg_collation
> entries is quite a bit different on my box than yours, as a result of a
> different list from "locale -a". It's hard to see why that would have
> anything to do with your issue, but I have a feeling it does somehow.
>
> What platforms have you tried this on, exactly? I tried it on Fedora 14.
>
> > What are the values of relevant locale-type env vars when you ran initdb on your test sys?
>
> Shrug ... C. That's my normal working environment. I did try it with
> en_US.utf8 too, just for grins.
>
> regards, tom lane
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
 		 	   		  

In response to

pgsql-bugs by date

Next:From: Wilfried.WeissDate: 2011-12-14 06:36:25
Subject: BUG #6334: initdb not working
Previous:From: Robert HaasDate: 2011-12-13 21:08:54
Subject: Re: could not truncate directory "pg_subtrans": apparent wraparound

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