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
> 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
>
> ---------------------------(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