Re: [GENERAL] Limitation

John Huttley wrote:

> 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.

John,
I generate a lot of sql create scripts from perl classes.
These scripts tend to hav a lot of whitespaces that make them beautiful
to read.
But just for me ... that's what PG means to this :

PQsendQuery() -- query is too long.  Maximum length is 8191

So far, I got along very well just stripping unneeded whitespaces out of
the scripts before i run them.
Probably a simple s/^       // would already help in your case.

Chris
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Christian Rudow                 E-Mail: Christian.Rudow@thinx.ch
ThinX networked business services    Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~