Re: Concurrent testing PostgreSQL Vs MySQL

From: Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com>
To: Durai <visolve_postgres(at)lycos(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Concurrent testing PostgreSQL Vs MySQL
Date: 2003-11-21 10:03:21
Message-ID: 3FBDE2E9.7010404@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 support the
> concurrent access to update database?
>
> I got the following errors:
>
> test=# ERROR: deadlock detected
> ERROR: deadlock detected
> ERROR: deadlock detected

Did you commited the transaction anywhere? Can we see the php code?

Shridhar

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Durai 2003-11-21 10:09:42 Re: Concurrent testing PostgreSQL Vs MySQL
Previous Message Julian North 2003-11-21 09:59:13 Re: Modelling Oracle Sequences