rule plan string too big

From: Rodrigo Rezende <Rodrigo(dot)Rezende(at)hortolandia(dot)marelli(dot)it>
To: pgsql-sql(at)postgresql(dot)org
Subject: rule plan string too big
Date: 2000-02-21 15:38:16
Message-ID: 38B15BE8.4B0BD398@hortolandia.marelli.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-02-21 22:27:08 Re: [SQL] Select & Tables X Select & Views
Previous Message Rodrigo Rezende 2000-02-21 12:42:59 Re: [SQL] Select & Tables X Select & Views