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

Поиск
Список
Период
Сортировка
От WildWezyr
Тема Re: BUG #5290: Simple loop with insert into and check to avoid duplicate values fails
Дата
Msg-id 26fec1f6-4efd-4771-9bc5-20f1d797e7c6@b10g2000yqa.googlegroups.com
обсуждение исходный текст
Ответ на BUG #5290: Simple loop with insert into and check to avoid duplicate values fails  ("WildWezyr" <wi.ld.we.zy.r@gmail.com>)
Список pgsql-bugs
On Jan 21, 6:17=A0pm, mi...@radev.net ("Milen A. Radev") wrote:
> [...]
>
> For the test I changed all regional settings to "Polish (Poland)",
> restarted the machine, created a new cluster and a new database (using
> the commands from the last mail from Heikki).
>
> A side-note: tested exactly the same function but on "Bulgarian
> (Bulgaria)" system locale and cluster and database created with
> "Bulgarian_Bulgaria.1251" locale - no errors.
>
> --
> Milen A. Radev


Strange (?), but when I substituted equality to like in this line:

        select id into wordId from spb_word where word like w; --
was: ... word =3D w;

there is no error with polish locale.


  (WW)

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

Предыдущее
От: Tim Bunce
Дата:
Сообщение: Re: Termination When Switching between PL/Perl and PL/PerlU
Следующее
От: "Milen A. Radev"
Дата:
Сообщение: Re: BUG #5290: Simple loop with insert into and check to avoid duplicate values fails