From: | "J(dot) Roeleveld" <j(dot)roeleveld(at)softhome(dot)net> |
---|---|
To: | "Robert Davis" <rdavis(at)lillysoftware(dot)com>, <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] cant create index on decimal column |
Date: | 1999-12-16 15:26:48 |
Message-ID: | 004a01bf47d9$f9fac5e0$8402a8c0@sentec.demon.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
try to delete the comma ( , ) behind
MINIMUM_COST DECIMAL(15,2),
because the way you have it atm. is that PostgreSQL thinks you want to
create a Primary Key, without a name or datatype.
Hope this helps,
Joost Roeleveld
> 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,WOR
KORDER_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?
From | Date | Subject | |
---|---|---|---|
Next Message | Rahul Ravindrudu | 1999-12-16 15:40:59 | REF function |
Previous Message | Robert Davis | 1999-12-16 15:11:40 | cant create index on decimal column |