From: | Robert Davis <rdavis(at)lillysoftware(dot)com> |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Subject: | cant create index on decimal column |
Date: | 1999-12-16 15:11:40 |
Message-ID: | 3859012C.3C6FAC7A@lillysoftware.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi I have a problem. I cant create indexes on decimal columns.
CREATE TABLE REQUIREMENT_COST(
WORKORDER_TYPE CHAR(1) NOT NULL,
WORKORDER_BASE_ID VARCHAR(30) NOT NULL,
WORKORDER_LOT_ID VARCHAR(3) NOT NULL,
WORKORDER_SPLIT_ID VARCHAR(3) NOT NULL,
WORKORDER_SUB_ID VARCHAR(3) NOT NULL,
OPERATION_SEQ_NO SMALLINT NOT NULL,
REQ_PIECE_NO SMALLINT NOT NULL,
QTY DECIMAL(14,4) NOT NULL,
UNIT_COST DECIMAL(14,4) NOT NULL,
FIXED_COST DECIMAL(15,2) NOT NULL,
MINIMUM_COST DECIMAL(15,2),
PRIMARY
KEY(WORKORDER_TYPE,WORKORDER_BASE_ID,WORKORDER_LOT_ID,WORKORDER_SPLIT_ID,WORKORDER_SUB_ID,OPERATION_SEQ_NO,REQ_PIECE_NO,QTY
))
;
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'requirement_cost_pkey'
for table 'requirement_cost'
ERROR: Can't find a default operator class for type 1700.
If the field qty is deleted from the above primary key the create works.
I assume that there is an operator I can add to fix this?
bob
--
rdavis(at)lillysoftware(dot)com
rsdavis(at)mediaone(dot)net
http://people.ne.mediaone.net/rsdavis
From | Date | Subject | |
---|---|---|---|
Next Message | J. Roeleveld | 1999-12-16 15:26:48 | Re: [GENERAL] cant create index on decimal column |
Previous Message | Nikolay Mijaylov | 1999-12-16 14:54:07 | char(xx) problem |