To Whom It May Concern
--------------------------------------
Hi,
we are using PostgreSQL 7.3.2 for some monthes and are very glad with overall perfomance and features of pgSQL !
But in the last time we experiencing some troubles with deadlocks in some tables :-(((. The problem occures from time to time if multiple transactions do UPDATE the same table. The found solution (or better to say "workaround") for this problem consists of removing all the foreign keys in this table. The question now - is there any other solution, because this workaround damages the referential integrity of the database ? We have tested the transaction isolation level SERIALIZEABLE, but with no success. Please help us. Thank you very much in advance !!!
Sincerely yours,
Alexander Goldybin