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

Heikki Linnakangas написа:
> 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;
>

I reproduced it on Windows Vista 64-bit SP2 with version 8.4.2
(installed by using the One-click installer from EnterpriseDB):

...
NOTICE: i = 642200
NOTICE: i = 642300
NOTICE: i = 642400
NOTICE: i = 642500
ERROR: duplicate key value violates unique constraint "spb_word_word_key"
CONTEXT: SQL statement "insert into spb_word (word) values ( $1 )"
PL/pgSQL function "spb_runmesimple2" line 15 at SQL statement

--
Milen A. Radev