| 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: | Whole Thread | Raw Message | 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] |