index refuses to build

Поиск
Список
Период
Сортировка
От Jean-Yves F. Barbier
Тема index refuses to build
Дата
Msg-id 20111230001001.5192e441@anubis.defcon1
обсуждение исходный текст
Ответы Re: index refuses to build  (Merlin Moncure <mmoncure@gmail.com>)
Re: index refuses to build [finally SOLVED, but still some questions]  ("Jean-Yves F. Barbier" <12ukwn@gmail.com>)
Список pgsql-novice
Hi list,

I'm wrong somewhere, but where?:

CREATE INDEX tst1m_name_lu_ix ON tst1m(lower(unaccent(name)));
ERROR:  functions in index expression must be marked IMMUTABLE

Decomposing it reveals that it is the 'unaccent' part that
blocks:

CREATE INDEX tst1m_name_lu_ix ON tst1m(unaccent(name));
ERROR:  functions in index expression must be marked IMMUTABLE

From what I found on the web I also tried to cast it to text,
but the error's still here:(

JY
--
One of the signs of Napoleon's greatness is the fact that he once
had a publisher shot.
        -- Siegfried Unseld

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

Предыдущее
От: "Jean-Yves F. Barbier"
Дата:
Сообщение: Re: column or index collation [SOLVED]
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: index refuses to build