Hi, Tom
Thnaks for you reply; I don't need timezone in this application so it's
okay.
However, I've been trying to change the table on 7.1.3 to get ready for
the swap but there's no timestamp without timezone on 7.1.3;
do I really have to edit the dump before reloading, ISTM that it's the
best way to generate errors...
Regards,
On Mon, 4 Mar 2002, Tom Lane wrote:
> Olivier PRENANT <ohp@pyrenet.fr> writes:
> > CREATE INDEX deb ON xxxx USING btree (date(timestamp coll) date_ops);
> > on 7.2 I have an error message saying that functrional indexes must but
> > made ISCACHABLE.
>
> See previous discussion of this identical problem. The fact is that
> such an index is dangerous, because it depends on the timezone setting.
>
> You might want to make the underlying column be timestamp without time
> zone.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)