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

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

From: "Milen A(dot) Radev" <milen(at)radev(dot)net>
To:
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5290: Simple loop with insert into and check to avoid duplicate values fails
Date: 2010-01-21 12:52:50
Message-ID: 4B584E22.8070802@radev.net (view raw or flat)
Thread:
Lists: pgsql-bugs
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

In response to

Responses

pgsql-bugs by date

Next:From: Scott MeadDate: 2010-01-21 14:52:52
Subject: Re: PHP .zip File
Previous:From: Wild WezyrDate: 2010-01-21 09:55:16
Subject: Re: BUG #5290: Simple loop with insert into and check to avoid duplicate values fails

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