Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-novice by date

Next:From: Merlin MoncureDate: 2011-12-29 23:16:22
Subject: Re: index refuses to build
Previous:From: Jean-Yves F. BarbierDate: 2011-12-29 20:59:26
Subject: Re: column or index collation [SOLVED]

pgsql-hackers by date

Next:From: Ants AasmaDate: 2011-12-29 23:12:44
Subject: Re: 16-bit page checksums for 9.2
Previous:From: Pavel StehuleDate: 2011-12-29 22:51:28
Subject: Re: failed regress test

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group