Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id A55019FB697 for ; Wed, 6 Jun 2007 15:14:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 35562-01-4 for ; Wed, 6 Jun 2007 15:13:44 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.169]) by postgresql.org (Postfix) with ESMTP id 18D619FBF50 for ; Wed, 6 Jun 2007 15:12:14 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id u2so546118uge for ; Wed, 06 Jun 2007 11:12:13 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=Q5mXUCF6n12X9MHhJCzfEDZeEXJbQoISQJuauewG4VkWPM3nr/KS2NX/KBsGULWGHlH2S9nn+ovBU17ZD0/tdr+pporso3+uU0N+RXI6MDyreqa6IH7fITC5dXvITq5ZdMYOzciATjotFAU/hpLiaoRdrpmajmk7p3ZPHIXsI8Y= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=XapzzOVDE5x1qazwJCs3c6NawPGcUU/rpXKBLU7maN1Rm+GjSiYnlhT2ED3uMc1KpWje+2QwL1lUrf1+DC3ujNssoTWLs6FuQU1CO23n6SVVkEv9EDh8TwkZLXHDoq31Jl1vw5RSJJhgvW9i2Vu5m5mNdxmMBbP82VTMfqE4/LA= Received: by 10.78.204.7 with SMTP id b7mr313681hug.1181153532930; Wed, 06 Jun 2007 11:12:12 -0700 (PDT) Received: by 10.78.201.16 with HTTP; Wed, 6 Jun 2007 11:12:12 -0700 (PDT) Message-ID: <1d219a6f0706061112p355fc6cexb30a6b4b4bf187c3@mail.gmail.com> Date: Wed, 6 Jun 2007 14:12:12 -0400 From: "Chris Hoover" To: "pgsql-admin@postgresql.org Admin" Subject: 8.2.4 Won't Build 8.1 Functional Indexes MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_35419_2431660.1181153532902" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.13 tagged_above=0 required=5 tests=AWL=-1.223, BAYES_50=0.001, HTML_10_20=1.351, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200706/44 X-Sequence-Number: 25712 ------=_Part_35419_2431660.1181153532902 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline I am testing upgrades to 8.2.4 from 8.1.3 and am having problems with 8.2.4balking 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 ------=_Part_35419_2431660.1181153532902 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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
------=_Part_35419_2431660.1181153532902--