Re: BUG #1811: unique index problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "George Jansen" <gjansen(at)aflcio(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1811: unique index problem
Date: 2005-08-08 15:30:49
Message-ID: 28715.1123515049@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"George Jansen" <gjansen(at)aflcio(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-08-08 16:20:56 Re: BUG #1809: invalid pointer on pg_ctl reload
Previous Message Tom Lane 2005-08-08 15:26:02 Re: Cache lookup failed !!!