Limitation

I've been attempting to port applications from Pervasive SQL to PG.
Pervasive is interesting because it runs on top of btrieve. This allow
legacy apps
and SQL systems to co-exist. It's quirky and buggy, but it's better than PG
because it can do the following.


1.  Have more than 7 fields on a btree index

2. There exists a table called inmaster it has a char(20) field called
stock_code.

pervasive can create a view (product) that splits the consituent characters
into fields.

PG cannot handle this. see below.

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
From INMASTER;
ERROR:  DefineQueryRewrite: rule plan string too big.


This should not occur. Would someone please pick it up and put it on the
TODO list.


Regards

John