Postgres Pro
Downloads
Home   >   mailing lists

ERROR: functions in index expression must be marked IMMUTABLE - Mailing list pgsql-admin

From naveen kumar
Subject ERROR: functions in index expression must be marked IMMUTABLE
Date
Msg-id CADye41Ko=g50J4P2mKYCXqDZm4YN5aDESntJmy+YRBDOfgcmUA@mail.gmail.com
Whole thread Raw
Responses Re: ERROR: functions in index expression must be marked IMMUTABLE  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
Tree view
Hello Experts..

postgres=# create index idx_calls_call_datetime on calls using btree ((call_datetime::date));
ERROR:  functions in index expression must be marked IMMUTABLE

bit confused with above error, can any one please help me on this, and if possible let me explain when this error occurs and what it does. Thanks in advance.
 

Thanks & Regards,
M Naveen Kuamr,
PostgreSQL Database Administrator, 
Mobile Number: +91 7755929449. 

pgsql-admin by date:

Previous
From: Vladimir Borodin
Date:
Subject: Hanging startup process on the replica after vacuuming on master
Next
From: "David G. Johnston"
Date:
Subject: Re: ERROR: functions in index expression must be marked IMMUTABLE