Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id D02E6475F24 for ; Fri, 10 May 2002 11:47:30 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 78A6E476850 for ; Fri, 10 May 2002 11:44:52 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g4AFioW28672; Fri, 10 May 2002 11:44:50 -0400 (EDT) To: nickf@ontko.com Cc: "pgsql-admin" , "Ray Ontko" Subject: Re: A couple of errors encountered in 7.1.3=>7.2.1-2 data migration In-reply-to: References: Comments: In-reply-to "Nick Fankhauser" message dated "Fri, 10 May 2002 09:11:57 -0500" Date: Fri, 10 May 2002 11:44:50 -0400 Message-ID: <28669.1021045490@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200205/84 X-Sequence-Number: 4259 "Nick Fankhauser" writes: > The load returned two errors that I don't understand: > ERROR: DefineIndex: index function must be marked iscachable This means what it says: add "with (iscachable)" to your function declaration. This is intended to remind you that it is not sensible to build an index on a function that has time-varying results... > ERROR: cannot find attribute 1 of relation schedule_notification_log This is more disturbing. Can you provide the sequence of commands that led up to it? regards, tom lane