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(dot)Rudow(at)thinx(dot)ch
ThinX networked business services Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~