Postgres Pro
Downloads
Home   >   mailing lists

Re: Trouble with pg_dumpall import with 7.2 - Mailing list pgsql-hackers

From Masaru Sugawara
Subject Re: Trouble with pg_dumpall import with 7.2
Date
Msg-id 20020217180517.FD9C.RK73@echna.ne.jp
Whole thread Raw
In response to Trouble with pg_dumpall import with 7.2  (Hervé Piedvache <herve@elma.fr>)
List pgsql-hackers
Tree view 
On Sun, 17 Feb 2002 01:15:40 +0100
HervPiedvache <herve@elma.fr> wrote:

> I have done what exactly explains the documentation for the migration from my databases in 7.1.3 to 7.2 ...
> 
> But during the importation in Postgresql v7.2 of the data from the pg_dumpall ...
> I get sometime this message :
> 
> psql:backup:24473309: ERROR:  DefineIndex: index function must be marked iscachable
> 
> backup is my pg_dumpall file ...
> Why this message ?
> May I have lost index ? or data ?
> 
> Could you explain me ?


Have you created indices on your functions defined without "with (iscachable)"
in 7.1.3 ?   If so,  an error in 7.2 (see below) will occur while you're 
upgrading PG by pg_dumpall, etc.  I would think you need to recreate
indices on your function redefined with it before dumping.  Instead, 
it seems to be OK that you redefine functions and create indices after
restoring as well. 
  ERROR:  DefineIndex: index function must be marked iscachable


Regards,
Masaru Sugawara

pgsql-hackers by date:

Previous
From: Brian Bruns
Date:
Subject: making way for DRDA
Next
From: Brian Bruns
Date:
Subject: Re: making way for DRDA