Port Bug Report: No primary key possible with type reltime & timestamp

From: Unprivileged user <nobody>
To: pgsql-ports(at)postgresql(dot)org
Subject: Port Bug Report: No primary key possible with type reltime & timestamp
Date: 1999-07-07 08:20:11
Message-ID: 199907070820.EAA51401@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-ports


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

Your name : Yves MARTIN
Your email address : Yves(dot)Martin(at)ensimag(dot)imag(dot)fr

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

Summary: No primary key possible with type reltime & timestamp

System Configuration
--------------------
Operating System : Solaris 2.6

PostgreSQL version : 6.5

Compiler used : egcs-2.91.66

Hardware:
---------
SunOS 5.6 Generic_105181-12 sun4u sparc SUNW,Ultra-Enterprise

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

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

Problem Description:
--------------------
Error message when trying to create a table
with a primary key on type reltime or timestamp

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

Test Case:
----------
create table periodes ( b reltime primary key ) ;
ERROR: Can't find a default operator class for type 703.

create table periodes ( b timestamp primary key ) ;
ERROR: Can't find a default operator class for type 1296.

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

Solution:
---------

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 1999-07-07 08:30:28 When(Where) does qual become a List ?
Previous Message Bruce Momjian 1999-07-07 08:16:51 Re: [HACKERS] Memory leaks in relcache

Browse pgsql-ports by date

  From Date Subject
Next Message Unprivileged user 1999-07-07 15:26:44 Port Bug Report: PostgreSQL misnames the UNIX-domain socket
Previous Message Bruce Momjian 1999-07-07 03:01:08 Re: [PORTS] built 6.4.2 on SCO OpenServer 5.0.5