[SQL] 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

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

2003-07-25 Thread Elielson Fontanezi
-general; pgsql-sql Assunto: Re: [GENERAL] [SQL] ERROR: DefineIndex: index function must be marked iscachable On Fri, 25 Jul 2003, Stephan Szabo wrote: > On Fri, 25 Jul 2003, Elielson Fontanezi wrote: > > > What can I do in this case? > > I could not found anythin

Re: [SQL] ERROR: DefineIndex: index function must be marked iscachable

2003-07-25 Thread Tomasz Myrta
Dnia 2003-07-25 21:09, Użytkownik Elielson Fontanezi napisał: Hi all! What can I do in this case? I could not found anything about iscachable. postgres$ cat in.sql create index bt_proposta_f01 on proposta using btree (func_cod_secretaria(nr_proponente)); postgres$ psql -d escola -f in.

Re: [SQL] ERROR: DefineIndex: index function must be marked iscachable

2003-07-25 Thread Stephan Szabo
On Fri, 25 Jul 2003, Elielson Fontanezi wrote: > What can I do in this case? > I could not found anything about iscachable. > > postgres$ cat in.sql > create index bt_proposta_f01 on proposta > using btree (func_cod_secretaria(nr_proponente)); > > postgres$ psql -d escola -f in.sql > psq

[SQL] 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