Postgres Pro
Downloads
Home   >   mailing lists

ERROR: DefineIndex: index function must be marked iscachable - Mailing list pgsql-general

From Lec
Subject ERROR: DefineIndex: index function must be marked iscachable
Date
Msg-id 3C8C9EA4.2C236FBC@pc.jaring.my
Whole thread Raw
Responses Re: ERROR: DefineIndex: index function must be marked iscachable  (Martijn van Oosterhout <kleptog@svana.org>)
Re: ERROR: DefineIndex: index function must be marked  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
Tree view 
With version 7.2, when I tried to create an index using the built-in
funtion date(), I got an error:

ai=> create index stl_date on stl(date(stl_trxdate) );
ERROR:  DefineIndex: index function must be marked iscachable

What does this mean?  I could do so under version 7.1.2

pgsql-general by date:

Previous
From: Fernando Lozano
Date:
Subject: Re: FREE ERD TOOL for POSTGRES ???
Next
From: Martijn van Oosterhout
Date:
Subject: Re: ERROR: DefineIndex: index function must be marked iscachable