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: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Wild Wezyr <wildwezyr(at)gmail(dot)com>, 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-20 20:53:01
Message-ID: 4B576D2D.505@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Tom Lane wrote:
> Wild Wezyr <wildwezyr(at)gmail(dot)com> writes:
>> 2010/1/19 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>>> What locale setting and database encoding are you using?
> 
>> Here are my settings:
> 
>> CREATE DATABASE spb
>>   WITH OWNER = wwspb
>>        ENCODING = 'UTF8'
>>        LC_COLLATE = 'Polish_Poland.1250'
>>        LC_CTYPE = 'Polish_Poland.1250'
>>        CONNECTION LIMIT = -1;
> 
> I tried the test case on Linux (Fedora 11) with locale pl_PL.utf8,
> and unsurprisingly failed to reproduce the problem.  So it's something
> specific to Windows.  Can anyone else reproduce it?

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.

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

In response to

Responses

pgsql-bugs by date

Next:From: Robert HaasDate: 2010-01-21 03:59:53
Subject: Re: BUG #5285: contrib\xml2 package's xpath_table function
Previous:From: Wild WezyrDate: 2010-01-20 20:49:14
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