pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
rule plan string too big.
4+ messages / 4 participants
[nested] [flat]

* rule plan string too big.
@ 1999-01-14 11:03 Dirk Lutzebaeck <lutzeb@aeccom.com>
  1999-01-14 11:21 ` Re: [SQL] rule plan string too big. Jan Wieck <jwieck@debis.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Dirk Lutzebaeck @ 1999-01-14 11:03 UTC (permalink / raw)
  To: pgsql-sql@hub.org


Umm, I am creating a big view and then I get:

PostgresSQL error message: ERROR:
DefineQueryRewrite: rule plan string too big.

This is on 6.4.2

Any hints?

Dirk



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] rule plan string too big.
  1999-01-14 11:03 rule plan string too big. Dirk Lutzebaeck <lutzeb@aeccom.com>
@ 1999-01-14 11:21 ` Jan Wieck <jwieck@debis.com>
  0 siblings, 0 replies; 4+ messages in thread

From: jwieck@debis.com @ 1999-01-14 11:21 UTC (permalink / raw)
  To: lutzeb@aeccom.com; +Cc: pgsql-sql@hub.org

>
>
> Umm, I am creating a big view and then I get:
>
> PostgresSQL error message: ERROR:
> DefineQueryRewrite: rule plan string too big.
>
> This is on 6.4.2
>
> Any hints?

    It's a known problem - not solved yet.

    Currently  the  only  possible  solution  is  to increase the
    blocksize (defaults to 8K). Don't forget to run initdb after!


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #





^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* rule plan string too big
@ 2000-02-21 15:38 Rodrigo Rezende <Rodrigo.Rezende@hortolandia.marelli.it>
  2000-02-21 23:57 ` Re: [SQL] rule plan string too big Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 1 reply; 4+ messages in thread

From: Rodrigo Rezende @ 2000-02-21 15:38 UTC (permalink / raw)
  To: 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?




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] rule plan string too big
  2000-02-21 15:38 rule plan string too big Rodrigo Rezende <Rodrigo.Rezende@hortolandia.marelli.it>
@ 2000-02-21 23:57 ` Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 0 replies; 4+ messages in thread

From: Peter Eisentraut @ 2000-02-21 23:57 UTC (permalink / raw)
  To: Rodrigo Rezende <Rodrigo.Rezende@hortolandia.marelli.it>; +Cc: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2000-02-21 23:57 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-01-14 11:03 rule plan string too big. Dirk Lutzebaeck <lutzeb@aeccom.com>
1999-01-14 11:21 ` Jan Wieck <jwieck@debis.com>
2000-02-21 15:38 rule plan string too big Rodrigo Rezende <Rodrigo.Rezende@hortolandia.marelli.it>
2000-02-21 23:57 ` Re: [SQL] rule plan string too big Peter Eisentraut <peter_e@gmx.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox