General Bug Report: can't create this view (rule plan string too big)

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : john huttley
Your email address : john(at)mwk(dot)co(dot)nz

Category : runtime: back-end: SQL
Severity : serious

Summary: can't create this view (rule plan string too big)

System Configuration
--------------------
Operating System : linux RH6.0

PostgreSQL version : 6.5-990613

Compiler used : egcs 1.1.2

Hardware:
---------
SMP Celeron 300, 128Mb

Versions of other tools:
------------------------

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

Problem Description:
--------------------
The following view cannot be created in 6.4.2 or 6.5.

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

Test Case:
----------
create view product as
Select code As Stock_Code,
Substr(Code,1,1) As Process_ID,
Substr(Code,2,2) As SubProcess_ID,
Substr(Code,4,1) As SubStrate_ID,
Substr(Code,5,2) As Length_ID,
Substr(Code,7,2) As Width_ID,
Substr(Code,9,2) As Thickness_ID,
Substr(Code,11,3) As Face_ID,
Substr(Code,14,1) As Facefinish_ID,
Substr(Code,15,3) As Back_ID,
Substr(Code,18,1) As Backfinish_ID,
Substr(Code,19,2) As Other_ID
>From INMASTER;

the definition of INMASTER is....

Create Table INMASTER (
"code" char(20),
"desc" varchar(30),
"alpha" char(1),
"namefiller" char(1),
"category" char(3),
"stockcat_no" int4,
"taxrate" float8,
"taxamount" float8,
"delete_flag" char(1),
"unit" varchar(4),
"std_cost" float8,
"avg_cost" float8,
"last_cost" float8,
"prev_last_cost" float8,
"volume" float8,
"price_unit" varchar(4),
"price1" float8,
"price2" float8,
"price3" float8,
"price4" float8,
"price5" float8,
"price6" float8,
"alt_code" varchar(20),
"vendor" varchar(6),
"qty_onhand" float8,
"qty_backord" float8,
"qty_onord" float8,
"qty_sold" float8,
"qty_purch" float8,
"qty_trf" float8,
"qty_adj" float8,
"qty_comm" float8,
"qty_future" float8,
"sales_mtd_qty" float8,
"sales_mtd_val" float8,
"sales_ytd_qty" float8,
"sales_ytd_val" float8,
"sales_ly_qty" float8,
"sales_ly_val" float8,
"purch_mtd_qty" float8,
"purch_mtd_val" float8,
"purch_ytd_qty" float8,
"purch_ytd_val" float8,
"cos_mtd_val" float8,
"cos_ytd_val" float8,
"cos_ly_val" float8,
"sales_mth1" float8,
"sales_mth2" float8,
"sales_mth3" float8,
"sales_mth4" float8,
"sales_mth5" float8,
"sales_mth6" float8,
"sales_mth7" float8,
"sales_mth8" float8,
"sales_mth9" float8,
"sales_mth10" float8,
"sales_mth11" float8,
"sales_mth12" float8,
"sk_qty" float8,
"sk_cost" float8,
"sk_count" float8,
"desc2" varchar(30),
"space" char(1),
"aged_ly_qty" float8,
"aged_ly1_qty" float8,
"aged_ly2_qty" float8,
"aged_ly_cost" float8,
"aged_ly1_cost" float8,
"aged_ly2_cost" float8,
"dt_flag" char(1),
"non_diminishing" char(1),
"source" char(1),
"group" char(3),
"catit" char(3),
"serial_lot_flag" char(1),
"serial_format" char(1),
"barcode1" varchar(20),
"barcode2" varchar(20),
"notes_dflen" int2,
"notes" varchar(206),
"qty_fwd" float8,
"qty_onreq" float8,
"weight" float8,
"volcm3" float8,
"sup_war_period" int4,
"sup_war_type" char(1),
"sup_war_other" varchar(20),
"cus_war_period" int4,
"cus_war_type" char(1),
"cus_war_other" varchar(20),
"fc_currency" varchar(3),
"fc_last_cost" float8,
"serial_length" int2,
"print_label" char(1),
"default_qty" float8,
"location_det" varchar(30),
"sell_unit" varchar(4),
"mstr_user1" varchar(10),
"mstr_user2" varchar(10),
"tariff_code" varchar(15),
"last_inv_cost" float8,
"exp_date_req" char(1),
"exp_period" int4,
"exp_flag" char(1),
"spare1" char(1),
"spare2" char(1),
"spare3" varchar(3),
"spare4" varchar(10),
"spare5" float8,
"spare6" float8,
"vad1" char(1),
"vad2" char(1),
"vad3" char(1),
"vad4" char(1),
"vad5" char(1),
"vad6" char(1),
"dataflex_fill_01" char(1),
"dataflex_recnum_one" int4,
constraint inmaster_pk primary key (
"code" )
);

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

Solution:
---------

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