Skip site navigation (1)
Skip section navigation (2)
While debugging an application, I just wanted to confirm from the list here:
Suppose I have a long running transaction which has a few updates and inserts running on some specific tables which means it has acquired Exclusive locks too during the transaction on specific table but if just before commit the client app crashes and the commit is never sent, will the Exclusive locks be automatically released?
---------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
Peripheral Links
Header And Logo
|
Site Navigation
Locking question?
- From: "Shoaib Mir" <shoaibmir(at)gmail(dot)com>
- To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
- Subject: Locking question?
- Date: Tue, 30 Jan 2007 00:54:45 +0500
While debugging an application, I just wanted to confirm from the list here:
Suppose I have a long running transaction which has a few updates and inserts running on some specific tables which means it has acquired Exclusive locks too during the transaction on specific table but if just before commit the client app crashes and the commit is never sent, will the Exclusive locks be automatically released?
---------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
- Follow-Ups:
- Re: Locking question?
- From: Alvaro Herrera
- Re: Locking question?
- Prev by Date: Re: Limit on number of users in postgresql?
- Next by Date: Re: Locking question?
- Previous by thread: VACUUM ANALYZE taking a long time, %I/O and %CPU very low
- Next by thread: Re: Locking question?
- Indexes: