From: | Unprivileged user <nobody> |
---|---|
To: | pgsql-ports(at)postgresql(dot)org |
Subject: | Port Bug Report: Can't create indicies on type "timestamp" |
Date: | 1999-06-29 18:24:26 |
Message-ID: | 199906291824.OAA27258@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-ports |
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Nathan Parker
Your email address : nparker(at)pobox(dot)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:
---------
--------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-06-29 18:33:07 | Re: [PORTS] Port Bug Report: Can't create indicies on type "timestamp" |
Previous Message | Unprivileged user | 1999-06-29 17:46:50 | Port Bug Report: parse error not detected on unterminated quote |