problem using Dataobject generator with postgresql and multiple schemas

From: Date: Thu, 10 Mar 2005 14:30:54 +0000
Subject: problem using Dataobject generator with postgresql and multiple schemas
Groups: php.pear.general 
Request: Send a blank email to pear-general+get-17945@lists.php.net to get a copy of this message
Hi, I'm trying to generate dataobjects for a pg database (7.4) using schemas. I'm using the latest stable dataobject and PHP 5.0.2 and I get the following error:
DB_DataObject_Generator   : 0       : CREATING FOR terena
[db_error: message="DB Error: insufficient data supplied" code=-20 mode=return level=notice prefix="" info="SELECT c.relname AS "Name" FROM pg_class c, pg_user u WHERE c.relowner = u.usesysid AND c.relkind = 'r' AND NOT EXISTS (SELECT 1 FROM pg_views WHERE viewname = c.relname) AND c.relname !~ '^(pg_|sql_)' UNION SELECT c.relname AS "Name" FROM pg_class c WHERE c.relkind = 'r' AND NOT EXISTS (SELECT 1 FROM pg_views WHERE viewname = c.relname) AND NOT EXISTS (SELECT 1 FROM pg_user WHERE usesysid = c.relowner) AND c.relname !~ '^pg_' [nativecode=ERROR: relation "area_events" does not exist]"] The full table name would be "terena.event.area_events" Any ideas? Also, I woud like to generate classes only for the tables in this particular schema, not for the whole database. Is that possible? TIA, Jeroen

« previous php.pear.general (#17945) next »