Re: Concurrent testing PostgreSQL Vs MySQL - Mailing list 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