From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Yves MARTIN <Yves(dot)Martin(at)ensisun(dot)imag(dot)fr> |
Cc: | pgsql-ports(at)postgreSQL(dot)org |
Subject: | Re: [PORTS] Port Bug Report: No primary key possible with type reltime & timestamp |
Date: | 1999-07-08 03:23:16 |
Message-ID: | 199907080323.XAA24377@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-ports |
Updated TODO item:
* Creating index of TIMESTAMP & RELTIME fails, rename to DATETIME(Thomas)
> 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.
>
--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-07-08 03:25:24 | Re: [HACKERS] RE: [GENERAL] Transaction logging |
Previous Message | Bruce Momjian | 1999-07-08 03:21:25 | Re: [HACKERS] Re: A couple comments about datetime |
From | Date | Subject | |
---|---|---|---|
Next Message | Unprivileged user | 1999-07-08 06:30:06 | Port Bug Report: basic.source and advance.source failed |
Previous Message | Bruce Momjian | 1999-07-08 02:05:22 | Re: [PORTS] Port Bug Report: calling notify in pl/pgsql proc causes core dump |