ERROR: DefineIndex: index function must be marked iscachable

From: Lec <englim(at)pc(dot)jaring(dot)my>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: ERROR: DefineIndex: index function must be marked iscachable
Date: 2002-03-11 12:10:12
Message-ID: 3C8C9EA4.2C236FBC@pc.jaring.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2002-03-11 12:45:41 Re: ERROR: DefineIndex: index function must be marked iscachable
Previous Message Fernando Lozano 2002-03-11 12:05:00 Re: FREE ERD TOOL for POSTGRES ???