Re: BUG #5290: Simple loop with insert into and check to avoid duplicate values fails - Mailing list pgsql-bugs

2010/1/20 Heikki Linnakangas <heikki.linnakangas@enterprisedb.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.
>
> --
>  Heikki Linnakangas
>  EnterpriseDB   http://www.enterprisedb.com
>

What OS you have on this Win32 box? Is it Windows Vista (like mine)?

What version of Postgres you have used? Is it 8.3.3 or 8.4.2 like mine?

What encoding/collation was your DB created with? Was it UTF8 /
'Polish_Poland.1250' ? As I posted - standard 'C' collation gives no errors,
so it is important to use 'Polish_Poland.1250' (this is one of three choices
I have on my box: 'C' / 'Polish_Poland.1250' / 'Posix').

If my code runs for long with no error - it is best to interrupt and than
run it again - it gives errors in unpredictable manner (but only for
'Polish_Poland.1250' collation)...

  (WW)