On Fri, Nov 21, 2003 at 03:39:42PM +0530, Durai wrote:
> The script content is:
>
> # cat testpgsql.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 ($dbcon
Durai wrote:
Hello Sridhar,
Now, It works. Thanks lot.
But Still I have doubt:
1. How MySQL works in this case? It has any default "autocommit"?
Depends. What version of mysql you are using? If you are using mysql 3.x and/or
non-innodb tables, you don't have transactions in
idhar Daithankar" <[EMAIL PROTECTED]>
To: "Shridhar Daithankar" <[EMAIL PROTECTED]>
Cc: "Durai" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
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*
*
*
$dbconn = pg_connect("host=172.16.1.158 port=5432 dbname=test
user=postgres");
$result = pg_exec ($dbconn, "begin;");
$resu
.
- Original Message -
From: "Shridhar Daithankar" <[EMAIL PROTECTED]>
To: "Durai" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, November 21, 2003 4:09 PM
Subject: Re: [GENERAL] Concurrent testing PostgreSQL Vs MySQL
Durai wrote:
Hello Shridhar,
The script content is:
**
*# cat te**stpgsql.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-
Użytkownik Durai napisał:
> Hello Shridhar,
>
> The script content is:
> ** *# cat te**stpgsql.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 ($dbcon
- Original Message -
From: "Shridhar Daithankar" <[EMAIL PROTECTED]>
To: "Durai" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, November 21, 2003 3:33
PM
Subject: Re: [GENERAL] Concurrent testing
PostgreSQL Vs MySQL
> Durai wrote:> >
Durai wrote:
Hi All,
I tested "concurrent testing" in MySQL. It works fine. But I
couldn't do in PostgreSQL 7.3.4 on HPUX IPF. I got deadlock problem. I
used the PHP script to update table( one script increment the column &
another one decrement the column). Is the postgres suppo
Hi All,
I tested "concurrent testing" in MySQL. It works
fine. But I couldn't do in PostgreSQL 7.3.4 on HPUX IPF. I got deadlock
problem. I used the PHP script to update table( one script increment the
column & another one decrement the column). Is the postgres support the
co
10 matches
Mail list logo
