index refuses to build
| От | Jean-Yves F. Barbier |
|---|---|
| Тема | index refuses to build |
| Дата | |
| Msg-id | 20111230001001.5192e441@anubis.defcon1 обсуждение исходный текст |
| Ответы |
Re: index refuses to build
Re: index refuses to build [finally SOLVED, but still some questions] |
| Список | 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 по дате отправления: