============================================================================
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:
---------
--------------------------------------------------------------------------