X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id EC66CD1B430 for ; Fri, 12 Dec 2003 00:37:21 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 39468-05 for ; Thu, 11 Dec 2003 20:36:53 -0400 (AST) Received: from smtp1.gigared.com (smtp1.gigared.com [200.68.216.5]) by svr1.postgresql.org (Postfix) with ESMTP id B5098D1B456 for ; Thu, 11 Dec 2003 20:36:49 -0400 (AST) Received: from 10.41.139.99 (unknown [10.41.139.99]) by smtp1.gigared.com (Postfix) with ESMTP id 7D47D41FC; Thu, 11 Dec 2003 21:33:44 -0300 (GMT) From: Martin Marques To: Robert Treat , Peter Eisentraut Subject: Re: [ADMIN] PHP and autocommit of PostgreSQL 7.4 Date: Thu, 11 Dec 2003 21:36:43 -0300 User-Agent: KMail/1.5.4 Cc: aspire420@hotpop.com, Sai Hertz And Control Systems , pgsql-php@postgresql.org References: <3FD8E2C0.5060803@sancharnet.in> <200312112317.59269.peter_e@gmx.net> <1071185106.1792.8265.camel@camel> In-Reply-To: <1071185106.1792.8265.camel@camel> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200312112136.43688.martin@bugs.unl.edu.ar> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/19 X-Sequence-Number: 2465 El Jue 11 Dic 2003 20:25, Robert Treat escribi=F3: >=20 > (personally i'm down with Scott, application developers should just use > begin/commit, but i've met some folks who really look at it the other > way) $db =3D DB::Connect("pgsql://user:pass@host/db"); $db->autocommit(false); $db->query(query1); $db->query(query2); $db->commit(); Changing the first line would make it work on Oracle, or Informix. :-) --=20 select 'mmarques' || '@' || 'unl.edu.ar' AS email; ----------------------------------------------------------------- Mart=EDn Marqu=E9s | mmarques@unl.edu.ar Programador, Administrador, DBA | Centro de Telem=E1tica Universidad Nacional del Litoral -----------------------------------------------------------------