Re: Trouble with pg_dumpall import with 7.2

Hi Masaru,

OK it's a bug of postgreSQL 7.2 ??

I can apply an index on the field datelog where this field is a
timestamp like :

create index ix_datelog_date on datelog (date(datelog);

ERROR:  DefineIndex: index function must be marked iscachable

Or could you explain me how to set date() iscachable ?

regards,

Masaru Sugawara a écrit :
> 
> 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
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org

-- 
Hervé Piedvache

Elma Ingenierie Informatique
6, rue du Faubourg Saint-Honoré
F-75008 - Paris - France 
http://www.elma.fr
Tel: +33-1-44949901
Fax: +33-1-44949902 
Email: herve@elma.fr