rule plan string too big - Mailing list pgsql-sql

From Rodrigo Rezende
Subject rule plan string too big
Date
Msg-id 38B15BE8.4B0BD398@hortolandia.marelli.it
Whole thread Raw
Responses Re: [SQL] rule plan string too big  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-sql
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?



pgsql-sql by date:

Previous
From: Rodrigo Rezende
Date:
Subject: Re: [SQL] Select & Tables X Select & Views
Next
From: Tom Lane
Date:
Subject: Re: [SQL] Select & Tables X Select & Views