Postgres Pro
Downloads
Home   >   mailing lists

Re: Error: for type 1700 - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: Error: for type 1700
Date
Msg-id 23284.958660641@sss.pgh.pa.us
Whole thread Raw
In response to Error: for type 1700  (Tomas <merkurit@takas.lt>)
List pgsql-interfaces
Tree view 
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

pgsql-interfaces by date:

Previous
From: Tomas
Date:
Subject: Error: for type 1700
Next
From: Karel Zak
Date:
Subject: Re: pgbash-2.1 released