Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id KAA19950
	for <pgsql-interfaces@postgresql.org>;
	Thu, 18 May 2000 10:37:31 -0400 (EDT)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id KAA23287;
	Thu, 18 May 2000 10:37:21 -0400 (EDT)
To: Tomas <merkurit@takas.lt>
cc: pgsql-interfaces@postgresql.org
Subject: Re: Error: for type 1700 
In-reply-to: <3923A826.2C0CDE9B@takas.lt> 
References: <3923A826.2C0CDE9B@takas.lt>
Comments: In-reply-to Tomas <merkurit@takas.lt>
	message dated "Thu, 18 May 2000 10:21:59 +0200"
Date: Thu, 18 May 2000 10:37:21 -0400
Message-ID: <23284.958660641@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Archive-Number: 200005/24

Tomas <merkurit@takas.lt> writes:
> ERROR from backend during clear: 'ERROR:  Can't find a default operator
> class for type 1700.

6.5 doesn't have any support for indexes on NUMERIC columns.  This
is fixed in 7.0 ... in the meantime I would think an integer column
would be a perfectly good substitute for NUMERIC(6,0) ...

			regards, tom lane