Re: BUG #5290: Simple loop with insert into and check to avoid duplicate values fails - Mailing list pgsql-bugs

Wild Wezyr <wildwezyr@gmail.com> writes:
> 2010/1/19 Tom Lane <tgl@sss.pgh.pa.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?

            regards, tom lane