RES: [GENERAL] ERROR: DefineIndex: index function must be marked iscachable

2003-07-25 Thread Elielson Fontanezi
Direct blocks: 0 read, 0 written --- -Mensagem original- De: Stephan Szabo [mailto:[EMAIL PROTECTED] Enviada em: sexta-feira, 25 de julho de 2003 16:47 Para: Elielson Fontanezi Cc: pgsql-general; pgsql-sql Assunto: Re: [GENERAL] ERROR: DefineIndex: index

[GENERAL] ERROR: DefineIndex: index function must be marked iscachable

2003-07-25 Thread Elielson Fontanezi
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:   c

[GENERAL] ERROR: DefineIndex: index function must be marked iscachable

2003-07-25 Thread Elielson Fontanezi
Hi all!       What can I do in this case?     I could not found anything about iscachable.   postgres$ cat in.sqlcreate index bt_proposta_f01 on propostausing btree (func_cod_secretaria(nr_proponente)); postgres$ psql -d escola -f in.sqlpsql:in.sql:2: ERROR:  DefineIndex: index function m