Thread

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

Unprivileged user <nobody> — 1999-07-07T08:20:11Z

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


Your name               : Yves MARTIN
Your email address      : Yves.Martin@ensimag.imag.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:
---------


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