General Bug Report: can't create this view (rule plan string too big) - Mailing list pgsql-bugs

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


Your name               : john huttley
Your email address      : john@mwk.co.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:
---------


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