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