Re: [SQL] RewriteDefine.c : Rule size

>> I'm using Postgres 6.4.2. I want to create a view, but a message appear :
>> ERROR: DefineQueryRewrite: rule plan string too big. What could be the
>> solution to avoid the problem? In fact, I have 31 columns in a table, and
>> i want to make a view on this table (with a line restrict = WHERE clause).

I get the same error from 6.5 when I create rules that are apparently too
complex. My table has 25 or so columns..

>> I watched the RewriteDefine.c code and saw : #define RULE_PLAN_SIZE BLCKSZ
>> I thought changing the value of this size, but I don't find the place to
>> modify the BLCKSZ value. But, before doing the modification and
>> recompile, I would like to have your opinion on the problem...perhaps is
>> there an easier way to resolve the problem.

wieck> Never did it, but the BLCKSZ is defined in include/config.h. That
wieck> is a file generated from config.h.in, so be sure to change it there
wieck> and reconfigure before recompiling.

Be careful here. We changed BLCKSZ and found some scary results:

First we multiplied it * 4. This improved the ability to handle complex
rules, but didn't go far enough... (it still wouldn't handle all of what we
wanted it to).

So we multiplied it * 8. Initdb complained about "float4 not defined". (As
I recall.. I'm not where the error message is and thus this may not be 100%
accurate...).

We quickly changed it back to the original size and are implementing
alternative rules... I can understand if it doesn't have enough working
space to do what I ask (or whatever the details are behind "rule plan string
too big") but if changing BLCKSZ breaks builtin types -- I don't want to mess
with it!!!