Re: Concurrent testing PostgreSQL Vs MySQL - Mailing list pgsql-general

Damn.. I forgot to begin the transaction..

Shridhar Daithankar wrote:
> Durai wrote:
>> Hello Shridhar,
>>                     The script content is:
>> ** *# cat te**stpgsql.php*
>> *
>> *<?php
>> $dbconn = pg_connect("host=172.16.1.158 port=5432 dbname=test
>> user=postgres");

$result = pg_exec ($dbconn, "begin;");

>> $result = pg_exec ($dbconn, "update table2 set C2=C2+1;");
>> $result = pg_exec ($dbconn, "update table2 set C2=C2-1;");
> $result = pg_exec ($dbconn, "commit;");
>> pg_close($dbconn);
>> ?>
>> #

Check this..

  Shridhar