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

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 (view raw or flat)
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

pgsql-bugs by date

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

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