Re: [ADMIN] PHP and autocommit of PostgreSQL 7.4 - Mailing list pgsql-php

From Martin Marques
Subject Re: [ADMIN] PHP and autocommit of PostgreSQL 7.4
Date
Msg-id 200312112136.43688.martin@bugs.unl.edu.ar
Whole thread Raw
In response to Re: [ADMIN] PHP and autocommit of PostgreSQL 7.4  (Robert Treat <xzilla@users.sourceforge.net>)
Responses Re: [ADMIN] PHP and autocommit of PostgreSQL 7.4  (Martin Marques <martin@bugs.unl.edu.ar>)
List pgsql-php
El Jue 11 Dic 2003 20:25, Robert Treat escribió:
>
> (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 = 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. :-)

--
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
-----------------------------------------------------------------
Martín Marqués                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telemática
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------


pgsql-php by date:

Previous
From: Robert Treat
Date:
Subject: Re: [ADMIN] PHP and autocommit of PostgreSQL 7.4
Next
From: Martin Marques
Date:
Subject: Re: [ADMIN] PHP and autocommit of PostgreSQL 7.4