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

2010/1/21 Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>

> 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
>

So - it seems like a problem with exactly versions 8.3.3 and 8.4.2 (I don't
know what version exactly you have after CSV HEAD) and Windows Vista.

And - what now? Is it over - because you cannot reproduce my error or I may
count on fix for this error? What else can I do - upgrade to newer version
of Postgres? Obviously - resolution of my problem is quite urgent to me...

(WW)