Received: from orion.SAPserv.Hamburg.dsh.de (Tpolaris2.sapham.debis.de [53.2.131.8]) by hub.org (8.9.1/8.9.1) with SMTP id GAA21911 for ; Thu, 14 Jan 1999 06:21:12 -0500 (EST) (envelope-from wieck@sapserv.debis.de) Received: by orion.SAPserv.Hamburg.dsh.de for pgsql-sql@hub.org id m100kq2-000EBQC; Thu, 14 Jan 99 12:21 MET Message-Id: From: jwieck@debis.com (Jan Wieck) Subject: Re: [SQL] rule plan string too big. To: lutzeb@aeccom.com (Dirk Lutzebaeck) Date: Thu, 14 Jan 1999 12:21:21 +0100 (MET) Cc: pgsql-sql@hub.org Reply-To: jwieck@debis.com (Jan Wieck) In-Reply-To: <199901141103.MAA02748@kamet.aeccom.com> from "Dirk Lutzebaeck" at Jan 14, 99 12:03:42 pm X-Mailer: ELM [version 2.4 PL25] Content-Type: text > > > 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) #