From: | Martin Neumann <mne(at)mne(dot)de> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Can't find a default operator class for type 1296. |
Date: | 2000-03-02 14:48:24 |
Message-ID: | E12QWts-00028g-00@darwin.oche.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
This occured when I was creating a table:
---------------snip-----------------------------------------------
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.
wp=> SELECT version();
version
-------------------------------------------------------------
PostgreSQL 6.5.3 on i686-pc-linux-gnu, compiled by gcc 2.95.2
(1 row)
---------------snip-----------------------------------------------
Changing 'datum' to type datetime helps, but datetime is deprecated in
PostgreSQL 7.0.
Does this work in 7.0 beta?
--
Martin Neumann, Welkenrather Str. 118c, 52074 Aachen, Germany
mne(at)mne(dot)de - http://www.mne.de/mne/ - sms(at)mne(dot)de [eMail2SMS]
Tel. 0241 / 8876-080 - Mobil: 0173 / 27 69 632
..------.---------------------------------------------------------
| at | Inform GmbH - Abteilung Airport Logistics
| work | Pascalstr. 23 - 52076 Aachen - Tel. 02408 / 9456-0
|______| martin(dot)neumann(at)inform-ac(dot)com - http://www.inform-ac.com
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2000-03-02 15:14:10 | Re: [GENERAL] Version 7.0 beta problem |
Previous Message | Jerome ALET | 2000-03-02 11:47:13 | grant/revoke bug with delete/update |