FAQ
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name : Nathan Parker
Your email address : nparker@pobox.com

Category : runtime: back-end
Severity : non-critical

Summary: Can't create indicies on type "timestamp"

System Configuration
--------------------
Operating System : Linux 2.0.36 RedHat

PostgreSQL version : 6.5

Compiler used : gcc 2.8.1

Hardware:
---------
Linux sprocket.beast.com 2.0.36 #10 Mon Mar 1 05:23:53 MST 1999 i486 unknown

Versions of other tools:
------------------------


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

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.

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

Test Case:
----------
% createdb foo
% psql foo
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.0 on i486-pc-linux-gnu, compiled by gcc 2.8.1]

type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: foo

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.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^


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

Solution:
---------


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

Search Discussions

Discussion Posts

Follow ups

Related Discussions

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