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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #5290: Simple loop with insert into and check to avoid duplicate values fails
Дата
Msg-id 18170.1264015863@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #5290: Simple loop with insert into and check to avoid duplicate values fails  (Wild Wezyr <wildwezyr@gmail.com>)
Ответы Re: BUG #5290: Simple loop with insert into and check to avoid duplicate values fails  (Wild Wezyr <wildwezyr@gmail.com>)
Re: BUG #5290: Simple loop with insert into and check to avoid duplicate values fails  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-bugs
Wild Wezyr <wildwezyr@gmail.com> writes:
> 2010/1/19 Tom Lane <tgl@sss.pgh.pa.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?

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Richard Neill
Дата:
Сообщение: Re: BUG #5293: constant function (date_trunc) is repeatedly evaluated inside loop
Следующее
От: Wild Wezyr
Дата:
Сообщение: Re: BUG #5290: Simple loop with insert into and check to avoid duplicate values fails