Re: Trouble with pg_dumpall import with 7.2

On Sun, 17 Feb 2002 01:15:40 +0100
Herv
Piedvache <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