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
> 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
pgsql-bugs by date
|Next:||From: Scott Mead||Date: 2010-01-21 14:52:52|
|Subject: Re: PHP .zip File|
|Previous:||From: Wild Wezyr||Date: 2010-01-21 09:55:16|
|Subject: Re: BUG #5290: Simple loop with insert into and check to avoid duplicate values fails|