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

Wild Wezyr wrote:
> 2010/1/20 Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
>
>> 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.
>
> What OS you have on this Win32 box? Is it Windows Vista (like mine)?

The login screen says:

Windows Server 2003 R2, Datacenter x64 Edition

> What version of Postgres you have used? Is it 8.3.3 or 8.4.2 like mine?

A fresh checkout from CVS HEAD.

> What encoding/collation was your DB created with? Was it UTF8 /
> 'Polish_Poland.1250' ?

Yes. I used:

bin\initdb -D data3 -E UTF-8 --locale=Polish_Poland.1250

and

CREATE DATABASE spb
WITH OWNER = "Administrator"
ENCODING = 'UTF8'
LC_COLLATE = 'Polish_Poland.1250'
LC_CTYPE = 'Polish_Poland.1250'
CONNECTION LIMIT = -1;

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