Re: Error: for type 1700

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tomas <merkurit(at)takas(dot)lt>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Error: for type 1700
Date: 2000-05-18 14:37:21
Message-ID: 23284.958660641@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Tomas <merkurit(at)takas(dot)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

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Karel Zak 2000-05-18 15:08:18 Re: pgbash-2.1 released
Previous Message Tomas 2000-05-18 08:21:59 Error: for type 1700