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