Re: Error during creation of indexes - Mailing list pgsql-general

From Tom Lane
Subject Re: Error during creation of indexes
Date
Msg-id 636.974787843@sss.pgh.pa.us
Whole thread Raw
In response to Error during creation of indexes  (Florian Steffen <fsteffen@urbanet.ch>)
List pgsql-general
Florian Steffen <fsteffen@urbanet.ch> writes:
> CREATE TABLE events (name NAME, description TEXT, date TINTERVAL);
> CREATE INDEX events_date_idx ON events (date);
> ERROR:  DefineIndex: type tinterval has no default operator class

> What does that mean ?

It means there's no support for indexes on tinterval.

tinterval is an obsolete, deprecated datatype; try interval instead.

            regards, tom lane

pgsql-general by date:

Previous
From: Joe Kislo
Date:
Subject: Transaction, Rollback and Database Corruption question,
Next
From: Tom Lane
Date:
Subject: Re: Transaction, Rollback and Database Corruption question,