Re: Concurrent testing PostgreSQL Vs MySQL

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(at)myrealbox(dot)com>
To: "Shridhar Daithankar" <shridhar_daithankar(at)myrealbox(dot)com>
Cc: "Durai" <visolve_postgres(at)lycos(dot)co(dot)uk>; <pgsql-general(at)postgresql(dot)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