Port Bug Report: Can't create table because of "no amop" error on index.

============================================================================
                        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:
---------


--------------------------------------------------------------------------