Re: [GENERAL] ERROR: DefineIndex: index function must be marked - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: [GENERAL] ERROR: DefineIndex: index function must be marked
Date
Msg-id 20030725124326.K38567-100000@megazone.bigpanda.com
Whole thread Raw
In response to ERROR: DefineIndex: index function must be marked iscachable  (Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>)
List pgsql-sql
On Fri, 25 Jul 2003, Elielson Fontanezi wrote:

>     Who can help me on that?
>
>     First of all, my envoronment is:
>         Linux netlab142.prodam 2.4.8-26mdk #1 Sun Sep 23 17:06:39 CEST 2001
> i686 unknown
>         pg_ctl (PostgreSQL) 7.2.

You should definately move to the highest 7.2 release (7.2.4 I think)
which shouldn't require a restore (although you should back up first in
any case).  I think there were some reasonably important fixes between
7.2.1 and 7.2.4.

> CREATE OR REPLACE FUNCTION func_cod_secretaria(INTEGER) RETURNS INTEGER AS '
>    DECLARE
>       v_nr_proponente ALIAS FOR $1;
>    BEGIN
>       return TRUNC(v_nr_proponente/100000,0)*100000
>    END;
> ' LANGUAGE 'plpgsql'
Add WITH (iscachable) after LANGUAGE 'plpgsql' to make the function usable
in the functional index unless I'm misremembering the old syntax.


pgsql-sql by date:

Previous
From: Elielson Fontanezi
Date:
Subject: ERROR: DefineIndex: index function must be marked iscachable
Next
From: Eric Clark
Date:
Subject: Re: locks and variable substitution