Thread: Port Bug Report: Can't create table because of "no amop" error on index.
Port Bug Report: Can't create table because of "no amop" error on index.
From
Unprivileged user
Date:
============================================================================ 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: --------- --------------------------------------------------------------------------