Horton

Re: [BUGS] Can't find a default operator class for type 1296.

Peter Eisentraut <peter_e@gmx.net>

View thread
From: Peter Eisentraut <peter_e@gmx.net>
To: Martin Neumann <mne@mne.de>
Cc: pgsql-bugs@postgresql.org
Date: 2000-03-04T17:05:10Z
Lists: pgsql-bugs 
Martin Neumann writes:

> CREATE TABLE kurse (
>   wkn    text      NOT NULL,
>   datum  timestamp NOT NULL,
>   ausg   float4,
>   rueckn float4,
>   zg     float4,
>   aussch float4,
>   PRIMARY KEY (wkn,datum)
> );
> NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'kurse_pkey' for table 'kurse'
> ERROR:  Can't find a default operator class for type 1296.

> Does this work in 7.0 beta?

Yes.

As I understand it, all the 'timestamp' code came from 'datetime'. The old
'timestamp' was a little stupid, so to say.

-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden