| 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: | Whole Thread | Raw Message | 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 |