X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2D96A3A4367 for ; Wed, 17 Nov 2004 09:47:54 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 95658-04 for ; Wed, 17 Nov 2004 09:47:46 +0000 (GMT) Received: from ns.di.univaq.it (unknown [193.204.130.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4773C3A4357 for ; Wed, 17 Nov 2004 09:47:46 +0000 (GMT) Received: from ns.di.univaq.it (ns.di.univaq.it [127.0.0.1]) by ns.di.univaq.it (8.12.11/8.12.11) with ESMTP id iAH9mmYJ008285 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Wed, 17 Nov 2004 10:48:48 +0100 Received: (from apache@localhost) by ns.di.univaq.it (8.12.11/8.12.11/Submit) id iAH9ml6A008284; Wed, 17 Nov 2004 10:48:47 +0100 X-Authentication-Warning: ns.di.univaq.it: apache set sender to ff@ascoli.biz using -f Received: from 195.223.183.238 (SquirrelMail authenticated user fioravan); by www.di.univaq.it with HTTP; Wed, 17 Nov 2004 10:48:47 +0100 (CET) Message-ID: <1971.195.223.183.238.1100684927.squirrel@195.223.183.238> Date: Wed, 17 Nov 2004 10:48:47 +0100 (CET) Subject: PEAR DB_DataObjects - PostgreSQL view error From: "Fabio Fioravanti" To: pgsql-php@postgresql.org User-Agent: SquirrelMail/1.4.3a-1 X-Mailer: SquirrelMail/1.4.3a-1 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-AntiVirus: checked by Vexira Milter 1.0.7; VAE 6.28.0.12; VDF 6.28.0.76 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/13 X-Sequence-Number: 2957 When I try to run createtables.php to create classes with: build_views = true I get the following error msg [db_error: message="DB Error: insufficient data supplied" code=-20 mode=return level=notice prefix="" info="SELECT viewname FROM pg_views [nativecode=ERROR: relation "view_column_usage" does not exist]"] however select * from pg_views where viewname='view_column_usage' does return a result. I'm using PHP Version 4.3.2 + Apache/1.3.24 + PostgreSQL 8.0.0 beta-dev1 on windows XP sp2 (bleah) Any hints?