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 IAA10438 for ; Tue, 6 Jul 1999 08:25: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 OAA27676 for ; Tue, 6 Jul 1999 14:30:18 GMT Message-ID: <3781F55B.16444B3A@illite.u-strasbg.fr> Date: Tue, 06 Jul 1999 14:23:55 +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: PB creating view : DefineQueryRewrite: rule plan string too big Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello, does someone know the solution for my problem when creating a view that seems to have something too big. In fact, the number of column in my table is more than twenty ! My request : create view vpg1 as select * from analyse_eau where progr='PG1'; The Error : ERROR: DefineQueryRewrite: rule plan string too big. Please help me Thanks ... -- 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 ------------------------------------------------------------