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

Tom Lane wrote:
> Wild Wezyr <wildwezyr(at)gmail(dot)com> writes:
>> 2010/1/19 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>>> What locale setting and database encoding are you using?
>
>> Here are my settings:
>
>> CREATE DATABASE spb
>> WITH OWNER = wwspb
>> ENCODING = 'UTF8'
>> LC_COLLATE = 'Polish_Poland.1250'
>> LC_CTYPE = 'Polish_Poland.1250'
>> CONNECTION LIMIT = -1;
>
> I tried the test case on Linux (Fedora 11) with locale pl_PL.utf8,
> and unsurprisingly failed to reproduce the problem. So it's something
> specific to Windows. Can anyone else reproduce it?

I happen to have access to a Win32 virtual machine just now. CVS HEAD,
built from sources on the VM.

Seems to work fine. The test case runs for ages, I'm at about 1/3
through it, and no errors this far. I'm going to have to kill it now.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com