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