Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id SAA18598
	for <pgsql-interfaces@postgresql.org>;
	Wed, 8 Sep 1999 18:15:06 -0400 (EDT)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id SAA01329;
	Wed, 8 Sep 1999 18:14:31 -0400 (EDT)
To: marten@feki.toppoint.de
cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Internal errors when creating views ... 
In-reply-to: Your message of Wed, 8 Sep 1999 19:11:17 -0700 (MST)
	<199909090211.TAA13857@feki.toppoint.de>
Date: Wed, 08 Sep 1999 18:14:31 -0400
Message-ID: <1327.936828871@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

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