Re: [HACKERS] Rule plan size for views?

Bruce Momjian <maillist@candle.pha.pa.us>

From: Bruce Momjian <maillist@candle.pha.pa.us>
To: mrogan@fpelectronics.com
Cc: hackers@postgreSQL.org
Date: 1998-02-28T22:25:42Z
Lists: pgsql-hackers
> 
> 
> Hello
> 
> What is the rule size for views?
> 
> This seems to have changed in this beta; I have a view that worked in a 
> previous beta but fails to create.  
> "ERROR: DefineQueryRewrite: rule plan string too big."
> 
> I have about 33 column headings with a join of 5 tables.
> 
> I have the latest cvsup tree as of a few minutes ago.
> Linux 2.0.30
> pgcc compiler

Yes.  More of the structure elements are dumped into the view than it
used to.  We hoped to allow larger block sizes in 6.3, but no luck.


-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)