Re: basic question about concurrent access

2006-08-24 Thread Waylan Limberg
On 8/24/06, Steve M <[EMAIL PROTECTED]> wrote: > > I have a basic question about concurrency. > [snip] > > Now Alice and Bob each edit the email address in the text field, but > they set it to different values; Alice sets it to > '[EMAIL PROTECTED]' and Bob sets it to '[EMAIL PROTECTED]'. Then > t

Re: basic question about concurrent access

2006-08-24 Thread Michael van der Westhuizen
Hi Steve, On 8/24/06, Steve M <[EMAIL PROTECTED]> wrote: > > I have a basic question about concurrency. > [snip] > > Now Alice and Bob each edit the email address in the text field, but > they set it to different values; Alice sets it to > '[EMAIL PROTECTED]' and Bob sets it to '[EMAIL PROTECTED]

basic question about concurrent access

2006-08-24 Thread Steve M
I have a basic question about concurrency. Suppose I have a table Users, with a column email_address, and a view that allows updating records from this table. Suppose further that two different sessions, Alice and Bob, have loaded the view on a specific record, say, record 15. The view shows the