============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : John Huttley
Your email address : John@mwk.co.nz
Category : runtime: back-end
Severity : serious
Summary: Can't create table because of "no amop" error on index.
System Configuration
--------------------
Operating System : Linux 2.2.5 -SMP RH5.9
PostgreSQL version : 6.4.2
Compiler used : RPM with Dist
Hardware:
---------
Twin Celeron 300Mhz, 128Mb RAM, 9Gb UW SCSI
Versions of other tools:
------------------------
Dunno, it's the RPM
--------------------------------------------------------------------------
Problem Description:
--------------------
Table 'sales' creates ok, but selects fail with
"no amop 403 6555369 1"
--------------------------------------------------------------------------
Test Case:
----------
Here's the schema. I'm porting a live system and have no scope
for changing the schema.
Create Table SALES (
"YEAR_ID" Char(4),
"TYPE" Char(2),
"BRANCH" Char(2),
"AREA" Char(2),
"SALESPERSON" Char(2),
"SG_FLAG" Char(1),
"CATEGORY" Char(3),
"CUSTTYPE" Char(2),
"INVTYPE" Char(1),
"MERCHANT" VarChar(6),
"USER_ID" VarChar(6),
"STOCKGROUP" Char(3),
"STOCK_CODE" Char(20),
"M01_QTY" Float8,
"M02_QTY" Float8,
"M03_QTY" Float8,
"M04_QTY" Float8,
"M05_QTY" Float8,
"M06_QTY" Float8,
"M07_QTY" Float8,
"M08_QTY" Float8,
"M09_QTY" Float8,
"M10_QTY" Float8,
"M11_QTY" Float8,
"M12_QTY" Float8,
"M01_GROSS" Float8,
"M02_GROSS" Float8,
"M03_GROSS" Float8,
"M04_GROSS" Float8,
"M05_GROSS" Float8,
"M06_GROSS" Float8,
"M07_GROSS" Float8,
"M08_GROSS" Float8,
"M09_GROSS" Float8,
"M10_GROSS" Float8,
"M11_GROSS" Float8,
"M12_GROSS" Float8,
"M01_NET" Float8,
"M02_NET" Float8,
"M03_NET" Float8,
"M04_NET" Float8,
"M05_NET" Float8,
"M06_NET" Float8,
"M07_NET" Float8,
"M08_NET" Float8,
"M09_NET" Float8,
"M10_NET" Float8,
"M11_NET" Float8,
"M12_NET" Float8,
"M01_REBATE" Float8,
"M02_REBATE" Float8,
"M03_REBATE" Float8,
"M04_REBATE" Float8,
"M05_REBATE" Float8,
"M06_REBATE" Float8,
"M07_REBATE" Float8,
"M08_REBATE" Float8,
"M09_REBATE" Float8,
"M10_REBATE" Float8,
"M11_REBATE" Float8,
"M12_REBATE" Float8,
"DATAFLEX_FILL_01" CHAR(1),
"DATAFLEX_RECNUM_ONE" Int4,
Constraint SALES_PK Primary Key (
"YEAR_ID",
"TYPE",
"BRANCH",
"AREA",
"SALESPERSON",
"SG_FLAG", "CATEGORY", "CUSTTYPE",
"INVTYPE","MERCHANT","USER_ID",
"STOCKGROUP", "STOCK_CODE"
)
);
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------