Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Not your father's question about deadlocks - Mailing list pgsql-general

From Gurjeet Singh
Subject Re: [HACKERS] Not your father's question about deadlocks
Date
Msg-id 65937bea0611161307s27bb6855k107469a4c6760754@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Not your father's question about deadlocks  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
On 11/17/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Gurjeet Singh" <singh.gurjeet@gmail.com> writes:
> Small implementation detail: Also keep a count of how many times the same
> session requested the same lock, and do not release the lock until he
> requests same number of releases.

No need for that, because there isn't any heap_unlock_tuple.

Cool... I didn't know we could get away with that in PG land!!

I assume unlocking is done by a COMMIT/ROLLBACK.

--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | yahoo }.com

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Not your father's question about deadlocks
Next
From: Jeff Davis
Date:
Subject: Re: PostgreSQL: Question about rules