Re: Theoretical Basis for SELECT FOR UPDATE
From: vc <boston103_at_hotmail.com>
Date: 6 Oct 2005 11:40:57 -0700
Message-ID: <1128624057.164591.271800_at_g44g2000cwa.googlegroups.com>
Date: 6 Oct 2005 11:40:57 -0700
Message-ID: <1128624057.164591.271800_at_g44g2000cwa.googlegroups.com>
vc wrote:
[...]
> Regarding the locking approach, I am not sure whether it can be
> implemented at all. How would you lock/freeze a set of rows in various
> tables to guarantee a consistent view across the database ?
Actually, it's pretty easy to lock and select the latest value say in SQL Server by using the updlock hint which essentially converts read locks to write locks. Received on Thu Oct 06 2005 - 20:40:57 CEST