Can't find a default operator class for type 1296.
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
From bouncefilter Thu Mar 2 10:14:55 2000
Received: from meryl.it.uu.se (root@meryl.it.uu.se [130.238.12.42])
by hub.org (8.9.3/8.9.3) with ESMTP id KAA26511
for <pgsql-general@postgreSQL.org>; Thu, 2 Mar 2000 10:14:17 -0500 (EST)
(envelope-from e99re41@DoCS.UU.SE)
Received: from Dront.DoCS.UU.SE (e99re41@Dront.DoCS.UU.SE [130.238.9.108])
by meryl.it.uu.se (8.8.5/8.8.5) with ESMTP id QAA16517;
Thu, 2 Mar 2000 16:14:12 +0100 (MET)
Received: from localhost (e99re41@localhost) by Dront.DoCS.UU.SE
(8.6.12/8.6.12) with ESMTP id QAA29186;
Thu, 2 Mar 2000 16:14:10 +0100
X-Authentication-Warning: Dront.DoCS.UU.SE: e99re41 owned process doing -bs
Date: Thu, 2 Mar 2000 16:14:10 +0100 (MET)
From: Peter Eisentraut <e99re41@DoCS.UU.SE>
Reply-To: Peter Eisentraut <peter_e@gmx.net>
To: Mark Jewiss <mark.jewiss@knowledge.com>
cc: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] Version 7.0 beta problem
In-Reply-To:
<Pine.BSO.4.21.0003021043470.25133-100000@mark.desktop.knowledge.com>
Message-ID: <Pine.GSO.4.02A.10003021612410.27493-100000@Dront.DoCS.UU.SE>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from QUOTED-PRINTABLE to 8bit by hub.org id KAA26572
Try this:
cd {srcdir}/src/bin/psql
make clean
make
ls
and show me what it says.
In the future, please direct bug reports to pgsql-bugs@postgresql.org.
On Thu, 2 Mar 2000, Mark Jewiss wrote:
Hello,
Have run a full installation process for this twice now, and have
experienced the same problem both times: a psql binary is not built.I've got around this by using the old 6.5.3 one, but still...
Running on OpenBSD 2.6.
If you need any files or logs from me, let me know - I can redo this in
full if required.Regards,
Mark.
--
Peter Eisentraut Sernanders v���g 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden
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