Re: [ADMIN] PHP and autocommit of PostgreSQL 7.4

From: Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: aspire420(at)hotpop(dot)com, Sai Hertz And Control Systems <sank89(at)sancharnet(dot)in>, pgsql-php(at)postgresql(dot)org
Subject: Re: [ADMIN] PHP and autocommit of PostgreSQL 7.4
Date: 2003-12-12 00:36:43
Message-ID: 200312112136.43688.martin@bugs.unl.edu.ar
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin 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(at)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(at)unl(dot)edu(dot)ar
Programador, Administrador, DBA | Centro de Telemática
Universidad Nacional
del Litoral
-----------------------------------------------------------------

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Somasekhar Bangalore 2003-12-12 04:29:23 Re: [GENERAL][HACKERS]data fragmentation
Previous Message Peter Eisentraut 2003-12-11 23:50:24 Re: [ADMIN] PHP and autocommit of PostgreSQL 7.4

Browse pgsql-php by date

  From Date Subject
Next Message Martin Marques 2003-12-12 12:43:09 Re: [ADMIN] PHP and autocommit of PostgreSQL 7.4
Previous Message Peter Eisentraut 2003-12-11 23:50:24 Re: [ADMIN] PHP and autocommit of PostgreSQL 7.4