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

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

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Wild Wezyr <wildwezyr(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, WildWezyr <wi(dot)ld(dot)we(dot)zy(dot)r(at)gmail(dot)com>, 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 09:10:13
Message-ID: 4B5819F5.2050903@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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

In response to

Responses

pgsql-bugs by date

Next: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
Previous:From: Wild WezyrDate: 2010-01-21 08:59:09
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