Re: Concurrent testing PostgreSQL Vs MySQL

Użytkownik Durai napisał:

 > 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, "update table2 set C2=C2+1;");
 > $result = pg_exec ($dbconn, "update table2 set C2=C2-1;");
 > pg_close($dbconn);


You have to read about transactions in PostgreSQL or you should turn on
autocommit in conf file...