Re: Problem with DB::isError

El Mié 04 Feb 2004 16:45, David Clymer escribió: > I'm having some problems with the DB::isError function identifying a > non-object as an error object (or so it seems). I'm using postgreSQL > 7.3.x. The relevant code is below: > > /*******************[ my code start ]***********************/ > > $sql_queries = array(); > > $sql_queries[0] = 'BEGIN'; > $sql_queries[1] = "INSERT INTO domain (name,table_name) > VALUES('$domainname','$tablename')"; > $sql_queries[2] = 'CREATE TABLE ' . $tablename . '_account () > INHERITS (domain_account_template)'; > $sql_queries[3] = 'CREATE TABLE ' . $tablename . '_alias () INHERITS > (domain_alias_template)'; > $sql_queries[4] = 'CREATE TABLE ' . $tablename . '_option () > INHERITS (domain_account_template)'; > $sql_queries[5] = 'END'; Please, remove the 'BEGIN' and hte 'END' queries and set autocommit to false: $db->autoCommit(false); When you finish with the real queries you do one of these: $db->commit(); or $db->rollback(); If you keep on having problems, then send us another mail, but use the commit and rollback functions in PEAR::DB -- 19:33:01 up 71 days, 1:49, 2 users, load average: 1.17, 0.82, 0.57 ----------------------------------------------------------------- Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral -----------------------------------------------------------------