Concurrent testing PostgreSQL Vs MySQL

From: "Durai" <visolve_postgres(at)lycos(dot)co(dot)uk>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Concurrent testing PostgreSQL Vs MySQL
Date: 2003-11-21 09:22:16
Message-ID: 0ec901c3b010$f90251f0$1a0110ac@dumco
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
....

Regs,
Durai.

---
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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Julian North 2003-11-21 09:23:53 Modelling Oracle Sequences
Previous Message Unihost Web Hosting 2003-11-21 09:20:55 Re: PGSQL on shared hosting