Re: [HACKERS] please? - Mailing list pgsql-hackers

From Pablo Funes
Subject Re: [HACKERS] please?
Date
Msg-id 199905311927.PAA01173@mancha.cs.brandeis.edu
Whole thread Raw
In response to Re: [HACKERS] please?  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
> > It allows me to read uncommited records without blocking.
>
> Yes, but that does not solve his problem.  He wants a single lock, and
> wants to test the lock, and immediately return if the lock fails.
>

If you know the read was dirty, you know there was somebody else
locking/writing the table or record, it's locked, you failed to lock.

Of course you should be able to aquire the lock in the same atomic
operation...


...Pablo

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] please?
Next
From: Tom Lane
Date:
Subject: Re: s_lock_stuck (was Problems w/ LO)