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(at)elma(dot)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(at)elma(dot)fr