| From: | Elielson Fontanezi <ElielsonF(at)prodam(dot)sp(dot)gov(dot)br> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org>, pgsql-sql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | ERROR: DefineIndex: index function must be marked iscachable |
| Date: | 2003-07-25 19:09:27 |
| Message-ID: | A799F7647794D311924A005004ACEA9709699783@cprodamibs249.prodam |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
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.sql
psql:in.sql:2: ERROR: DefineIndex: index function must be marked iscachable
postgres$
>\\\!/< 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
---------------------------( )----------(
)--------------------------------
\ ( ) /
\_/ \_/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2003-07-25 19:21:15 | Re: [SQL] ERROR: DefineIndex: index function must be marked iscachable |
| Previous Message | Jonathan Mezach | 2003-07-25 19:06:50 | Updating from update trigger |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2003-07-25 19:21:15 | Re: [SQL] ERROR: DefineIndex: index function must be marked iscachable |
| Previous Message | gack | 2003-07-25 18:49:12 | locks and variable substitution |