Re: A couple of errors encountered in 7.1.3=>7.2.1-2 data migration

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: nickf(at)ontko(dot)com
Cc: "pgsql-admin" <pgsql-admin(at)postgresql(dot)org>, "Ray Ontko" <rayo(at)ontko(dot)com>
Subject: Re: A couple of errors encountered in 7.1.3=>7.2.1-2 data migration
Date: 2002-05-10 15:44:50
Message-ID: 28669.1021045490@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Nick Fankhauser" <nickf(at)ontko(dot)com> 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message William Meloney 2002-05-10 16:21:14 BufferLookup table corrupted
Previous Message Tom Lane 2002-05-10 15:40:01 Re: Input/output error