index refuses to build

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

Responses

Browse pgsql-hackers by date

  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

Browse pgsql-novice by date

  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]