Re: User Level Lock question - Mailing list pgsql-hackers

From Neil Conway
Subject Re: User Level Lock question
Date
Msg-id 1016231042.26927.14.camel@jiro
Whole thread Raw
In response to Re: User Level Lock question  ("Lance Ellinghaus" <lellinghaus@yahoo.com>)
Responses Re: User Level Lock question  (Greg Copeland <greg@CopelandConsulting.Net>)
List pgsql-hackers
On Fri, 2002-03-15 at 14:54, Lance Ellinghaus wrote:
> I know it does not sound like something that would need to be done, but here
> is why I am looking at doing this...
> 
> I am trying to replace a low level ISAM database with PostgreSQL. The low
> level ISAM db allows locking a record during a read to allow Exclusive
> access to the record for that process. If someone tries to do a READ
> operation on that record, it is skipped.

If the locked record is skipped, how can the application be sure it is
getting a consistent view of the data?

Cheers,

Neil

-- 
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC



pgsql-hackers by date:

Previous
From: Greg Copeland
Date:
Subject: Re: User Level Lock question
Next
From: Greg Copeland
Date:
Subject: Re: User Level Lock question