FAQ

PostgreSQL version : 6.5

Compiler used : gcc 2.8.1

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. Thanks for all
the good work.

--------------------------------------------------------------------------


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.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
I can confirm this as a bug.

--
Bruce Momjian | http://www.op.net/~candle
maillist@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 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