8.2.4 Won't Build 8.1 Functional Indexes - Mailing list pgsql-admin

From Chris Hoover
Subject 8.2.4 Won't Build 8.1 Functional Indexes
Date
Msg-id 1d219a6f0706061112p355fc6cexb30a6b4b4bf187c3@mail.gmail.com
Whole thread Raw
Responses Re: 8.2.4 Won't Build 8.1 Functional Indexes  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-admin
I am testing upgrades to 8.2.4 from 8.1.3 and am having problems with 8.2.4 balking at the functional indexes I have created.  These indexes exist and work fine in 8.1.3, so why is 8.2.4 rejecting them?

Index 1:
CREATE INDEX acceptedbilling_to_date_accepted_billing_dt_idx
  ON acceptedbilling
  USING btree
  (to_date(accepted_billing_dt::text, 'yyyymmdd'::text));.

Reject:
ERROR: functions in index expression must be marked IMMUTABLE
SQL state: 42P17

Index 2:
CREATE INDEX header_835_billing_idx
  ON ct_835.header_835
  USING btree
  (to_date(to_char(create_timestamp, 'yyyy-mm-dd'::text), 'yyyy-mm-dd'::text));

Reject:
ERROR: functions in index expression must be marked IMMUTABLE
SQL state: 42P17


This is on 8.2.4 installed from the official RPMS.

thanks,

Chris
RH AS 4
PG 8.2.4 from RPMS

pgsql-admin by date:

Previous
From: Erwin Brandstetter
Date:
Subject: Re: get the array content whis the select clause
Next
From: Andrew Sullivan
Date:
Subject: Re: the right time to vacuum database?