| From: | Wild Wezyr <wildwezyr(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | 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:49:14 |
| Message-ID: | 94a2fe2c1001201249v50779ce1j33c6b0cb479e718a@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
2010/1/20 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>
> 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?
>
> regards, tom lane
>
If it is of any help: changing LC_COLLATE and LC_CTYPE to 'C' eliminates the
error.
But when DB is created with LC_COLLATE and LC_CTYPE set to
'Polish_Poland.1250' I get errors (sometimes fast, sometimes I have to wait
for several minutes).
This corellation to locale 'C' / 'Polish_Poland.1250' was tested on two
Windows Vista boxes. Elimination of polish national characters from
generated words for locale 'Polish_Poland.1250' leads to same behavior - no
errors.
(WW)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2010-01-20 20:53:01 | Re: BUG #5290: Simple loop with insert into and check to avoid duplicate values fails |
| Previous Message | Tom Lane | 2010-01-20 19:31:03 | Re: BUG #5290: Simple loop with insert into and check to avoid duplicate values fails |