From: Tom Lane <tgl@sss.pgh.pa.us>
To: marten@feki.toppoint.de
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Internal errors when creating views ...
Date: Wed, 08 Sep 1999 18:14:31 -0400
Message-ID: <1327.936828871@sss.pgh.pa.us> (raw)
In-Reply-To: <199909090211.TAA13857@feki.toppoint.de>
marten@feki.toppoint.de writes:
> The frontend gets the error message: "DefineQueryRewrite: rule plan
> string too big"
Which means exactly what it says, I'm afraid. Jan has some ideas about
supporting longer rules in 6.6 by compressing the rule definition, and
the whole problem should go away when we implement unlimited-size
tuples, but for now there is a definite and rather tight limit on the
size of rules :-(. And of course, views are just a special case of
rules.
A partial workaround is to increase the disk block size from 8k to
16k or 32k in config.h. Note this requires a reinstall and initdb!
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, marten@feki.toppoint.de
Subject: Re: [INTERFACES] Internal errors when creating views ...
In-Reply-To: <1327.936828871@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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