Re: [BUGS] Can't find a default operator class for type 1296. - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: [BUGS] Can't find a default operator class for type 1296.
Date
Msg-id Pine.LNX.4.21.0003040342300.489-100000@localhost.localdomain
Whole thread Raw
In response to Can't find a default operator class for type 1296.  (Martin Neumann <mne@mne.de>)
List 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

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [BUGS] grant/revoke bug with delete/update
Next
From: Peter Eisentraut
Date:
Subject: Re: [BUGS] pg_dumpall