Thread: rule plan string too big

Hello all,

I ran the command :

create view func_stat as
select * from func_preench where codfuncionario||text(data)in(select
codfuncionario||text(max(data))from func_preench group by
codfuncionario);

and Postgres return :

ERROR:  DefineQueryRewrite: rule plan string too big. (State:S0001,
Native Code: 11)

How can I resolve it?

On 2000-02-21, Rodrigo Rezende mentioned:

> ERROR:  DefineQueryRewrite: rule plan string too big. (State:S0001,
> Native Code: 11)
> 
> How can I resolve it?

Make the view definition smaller, in the worst case to having no view at
all. This is a known deficiency.

-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden

Hi!
 Does PostgreSQL performs procedures and triggers special managment and execution caching? (What Algorith?) Or it
simplyexecutes it from hard drive?
 

Regards, Alexey V. Meledin
InterForge Developers Group, Saint-Petersburg
look_to: <www.etcompany.ru><www.businessweb.ru>
<www.inplan.spb.ru><www.pia.ru>>>>>>>>>>>>>>>>>
mail_to: <avm@webclub.ru><nick_as: <cureman>>>>