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 21124.1263939795@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #5290: Simple loop with insert into and check to avoid duplicate values fails  ("WildWezyr" <wi.ld.we.zy.r@gmail.com>)
Ответы Re: BUG #5290: Simple loop with insert into and check to avoid duplicate values fails  (Wild Wezyr <wildwezyr@gmail.com>)
Список pgsql-bugs
"WildWezyr" <wi.ld.we.zy.r@gmail.com> writes:
> If I eliminate polish national chars from function spb_getWord i.e. it will
> generate words with plain ascii chars there is no error and everything works
> fine.

What that sounds like is a locale/encoding conflict.  Postgres depends
on strcoll() or local equivalent to produce consistent sort results,
and sometimes if strcoll is presented with data that it thinks is
invalidly encoded, it doesn't behave sanely.

What locale setting and database encoding are you using?

            regards, tom lane

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

Предыдущее
От: "Chris Arensdorf"
Дата:
Сообщение: BUG #5291: Password change restrictions
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #5291: Password change restrictions