Re: Re: BUG #5290: Simple loop with insert into and check to avoid duplicate values fails

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Milen A(dot) Radev" <milen(at)radev(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Re: BUG #5290: Simple loop with insert into and check to avoid duplicate values fails
Date: 2010-01-21 15:45:52
Message-ID: 8223.1264088752@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Milen A. Radev" <milen(at)radev(dot)net> writes:
> I reproduced it on Windows Vista 64-bit SP2 with version 8.4.2
> (installed by using the One-click installer from EnterpriseDB):

OK, so that means WildWezyr isn't just seeing things. Possibilities
that occur to me now:

1. Maybe it's specific to Vista and/or Win64?

2. I wonder whether setting LC_COLLATE/LC_CTYPE during database creation
is really sufficient to establish the locale fully on Windows. If
wcscoll() is partially dependent on some other bit of state, maybe that
would explain the problem. What is the "surrounding" locale in your
test case?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kevin Grittner 2010-01-21 16:15:29 Re: BUG #5292: Corrupted installer
Previous Message Scott Mead 2010-01-21 14:52:52 Re: PHP .zip File