Re: [BUGS] No index support for date/time types? - Mailing list pgsql-bugs

From Oliver Fischer
Subject Re: [BUGS] No index support for date/time types?
Date
Msg-id m11lfQF-000HFUC@www.xshare.com
Whole thread Raw
List pgsql-bugs
Hi,

i have the same problem! Is it possible that postgres don´t
support
this feature?

Bye,
Oliver

> I'm getting some strange errors when trying to use a btree
(default)
> index
> on any of timestamp, abstime, datetime, or reltime types.  All
fail
> with an
> error:

> (timestamp)  ERROR:  Can't find a default operator class for
type
> 1296.
> (abstime)  ERROR:  Cannot create index: attribute 11 does not
exist
> (reltime)  ERROR:  Can't find a default operator class for type
703.
> (datetime)  ERROR:  Cannot create index: attribute 12 does not
exist

> ...errors which, of course, mean nothing to me.  8-)

> A simple case to reproduce the first ...

> create table foo (bar timestamp);
> create index baz on foo (bar);

> --
> -- Todd Vierling (tv@pobox.com)


> ************



#--{ plexus@snafu.de }----------------------------
Oliver Fischer, Gleimstrasse 59, 10437 Berlin, Germany

pgsql-bugs by date:

Previous
From: Chana Slutzkin
Date:
Subject: bug report
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] Possible bug in postgres || libpq