Re: [GENERAL] Concurrent testing PostgreSQL Vs MySQL

[Shridhar Daithankar]

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster