Can't find a default operator class for type 1296.
От | Martin Neumann |
---|---|
Тема | Can't find a default operator class for type 1296. |
Дата | |
Msg-id | E12QWts-00028g-00@darwin.oche.de обсуждение исходный текст |
Ответы |
Re: [BUGS] Can't find a default operator class for type 1296.
|
Список | 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@mne.de - http://www.mne.de/mne/ - sms@mne.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.neumann@inform-ac.com - http://www.inform-ac.com
В списке pgsql-bugs по дате отправления: