Re: Bug or Feature?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ohp(at)pyrenet(dot)fr
Cc: pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Bug or Feature?
Date: 2002-03-04 15:08:13
Message-ID: 3884.1015254493@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Olivier PRENANT <ohp(at)pyrenet(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-03-04 15:27:29 Re: Some additions/#ifdefs to target new OS NetWare
Previous Message Tom Lane 2002-03-04 15:02:31 Re: permanent EuroDates