Re: BUG #1811: unique index problem - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1811: unique index problem
Date
Msg-id 28715.1123515049@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1811: unique index problem  ("George Jansen" <gjansen@aflcio.org>)
List pgsql-bugs
"George Jansen" <gjansen@aflcio.org> writes:
> [ inconsistent comparison behavior ]
> Both old and new databases use SQL_ASCII. Is this a bug?

I think it's probably a locale problem; did you initdb the database in C
locale?  (Check SHOW LC_COLLATE and SHOW LC_CTYPE to be sure.)  Usually
we see this sort of thing when the locale is expecting characters in a
different encoding than what's actually being stored.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Cache lookup failed !!!
Next
From: Tom Lane
Date:
Subject: Re: BUG #1809: invalid pointer on pg_ctl reload