Re: [GENERAL] More information on how to understand table pg_locks.

2007-03-13 Thread Olivier Ceulemans
our help ! -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: mardi 13 mars 2007 16:57 To: Olivier Ceulemans Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] More information on how to understand table pg_locks. "Olivier Ceulemans" <[EMAIL PROTECTED]> wri

[GENERAL] More information on how to understand table pg_locks.

2007-03-13 Thread Olivier Ceulemans
Hi All, I wrote an application making 'advanced' use of transactions. The application is not tied to a specific kind of database. It runs fine on oracle, db2, sql server but I run into a deadlock on postgresql. I have two transactions (let's say A & B). These two transactions are initiated by t