ERROR: DefineIndex: index function must be marked iscachable

Поиск
Список
Период
Сортировка
От Elielson Fontanezi
Тема ERROR: DefineIndex: index function must be marked iscachable
Дата
Msg-id A799F7647794D311924A005004ACEA9709699785@cprodamibs249.prodam
обсуждение исходный текст
Ответы Re: ERROR: DefineIndex: index function must be marked
Список pgsql-general
Дерево обсуждения
Hi!
 
    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.
 
    Problem: ERROR:  DefineIndex: index function must be marked iscachable by executing:
 
create index bt_proposta_f01 on proposta
using btree (func_cod_secretaria(nr_proponente));
 
    Where nr_proponte is a integer type column.
 
    The function is:
 
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';

                                   >\\\!/<     55 11 5080 9283
                                   !_"""_!     Elielson Fontanezi
                                   (O) (o)     PRODAM - Technical Support Analyst
-------------------------------oOOO--(_)--OOOo-----------------------------------
     Success usually comes to those who are too busy to be looking for it.
                            oooo0          0oooo
---------------------------(    )----------(    )--------------------------------
                            \  (            )  /
                             \_/            \_/

 

В списке pgsql-general по дате отправления: