pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedrule 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>
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:21 Jan Wieck <jwieck@debis.com>
parent: Dirk Lutzebaeck <lutzeb@aeccom.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>
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 23:57 Peter Eisentraut <peter_e@gmx.net>
parent: Rodrigo Rezende <Rodrigo.Rezende@hortolandia.marelli.it>
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