From: | "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | index refuses to build |
Date: | 2011-12-29 23:10:01 |
Message-ID: | 20111230001001.5192e441@anubis.defcon1 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers 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
From | Date | Subject | |
---|---|---|---|
Next Message | Ants Aasma | 2011-12-29 23:12:44 | Re: 16-bit page checksums for 9.2 |
Previous Message | Pavel Stehule | 2011-12-29 22:51:28 | Re: failed regress test |
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2011-12-29 23:16:22 | Re: index refuses to build |
Previous Message | Jean-Yves F. Barbier | 2011-12-29 20:59:26 | Re: column or index collation [SOLVED] |