Received: from illite.u-strasbg.fr (illite.u-strasbg.fr [130.79.144.2]) by hub.org (8.9.3/8.9.3) with SMTP id MAA81252 for ; Thu, 8 Jul 1999 12:16:18 -0400 (EDT) (envelope-from ertz@illite.u-strasbg.fr) Received: from illite.u-strasbg.fr (huntite.u-strasbg.fr [130.79.144.187]) by illite.u-strasbg.fr (8.6.11/8.6.9) with ESMTP id SAA03752 for ; Thu, 8 Jul 1999 18:21:33 GMT Message-ID: <3784CE8B.9E412BB3@illite.u-strasbg.fr> Date: Thu, 08 Jul 1999 18:15:07 +0200 From: Olivier Ertz X-Mailer: Mozilla 4.6 [fr] (WinNT; I) X-Accept-Language: fr MIME-Version: 1.0 To: "pgsql-sql@postgreSQL.org" Subject: RewriteDefine.c : Rule size Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello, I'm using Postgres 6.4.2. I want to create a view, but a message appear : ERROR: DefineQueryRewrite: rule plan string too big. What could be the solution to avoid the problem? In fact, I have 31 columns in a table, and i want to make a view on this table (with a line restrict = WHERE clause). I watched the RewriteDefine.c code and saw : #define RULE_PLAN_SIZE BLCKSZ I thought changing the value of this size, but I don't find the place to modify the BLCKSZ value. But, before doing the modification and recompile, I would like to have your opinion on the problem...perhaps is there an easier way to resolve the problem. Thank you for answering -- ERTZ Olivier - ertz@illite.u-strasbg.fr - Tel 03 88 35 85 87 ------------------------------------------------------------ Etudiant DESS Informatique | Stagiaire EOST/ULP-CGS Universite Louis Pasteur | Ecole et Observatoire des STRASBOURG - France | Sciences de la Terre ------------------------------------------------------------ World Wide Web : http://dess-info.u-strasbg.fr/~ertz ------------------------------------------------------------