Hello Sridhar,
Now, It works. Thanks lot.
But Still I have doubt:
1. How MySQL works in this case? It has any default "autocommit"?
2. Is there any other method to test for "concurrent testing"?
Regs,
Durai.
----- Original Message -----
From: "Shridhar Daithankar" <shridhar_daithankar@myrealbox.com>
To: "Shridhar Daithankar" <shridhar_daithankar@myrealbox.com>
Cc: "Durai" <visolve_postgres@lycos.co.uk>; <pgsql-general@postgresql.org>
Sent: Friday, November 21, 2003 5:28 PM
Subject: Re: [GENERAL] Concurrent testing PostgreSQL Vs MySQL
> 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
>
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.538 / Virus Database: 333 - Release Date: 11/11/2003