FAQ

Summary: Can't create indicies on type "timestamp"
Problem Description:
--------------------
Whenever I try to create an index that includes a "timestamp"
field, I get this error:
ERROR: Can't find a default operator class for type 1296.
This prevents me from using the timestamp type altogether.
Big bummer. I like PostgreSQL, but I'm thinking of
switching to Sybase's free Linux server.
*shrug* Go fer it dude! But you might want to RTFM before switching ;)
foo=> create table foo1 (ts timestamp);
CREATE
foo=> create index foo1_idx on foo1 (ts);
ERROR: Can't find a default operator class for type 1296.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
The current timestamp type is *not* well supported. You should be
using the "datetime" type, which will become the "timestamp" type
sometime soon. In fact, it should probably happen for the next
release. I'd been waiting for a *major* release to make this switch,
but it doesn't seem worth the wait.

Check the chapter on "Data Types" in the User's Guide for pointers on
the date/time types.

Good luck.

- Thomas

--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 3 of 3 | next ›
Discussion Overview
grouppgsql-ports @
categoriespostgresql
postedJun 29, '99 at 6:24p
activeJun 30, '99 at 1:48p
posts3
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase