RE: Select for update

[prev] [thread] [next] [Date index for 2004/07/19]

From: Perrin Harkins
Subject: RE: Select for update
Date: 16:55 on 19 Jul 2004

On Mon, 2004-07-19 at 12:08, Ian McDonald-ONLINE wrote:
> Will it guarantee that no other process will start a transaction
> affecting the same rows at the same time?

Only if you set your isolation level to "serializable."  Make sure to
read all the details of how your particular database interprets
isolation levels before trying this. 

- Perrin

Select for update
Ian McDonald-ONLINE 13:15 on 19 Jul 2004

Re: Select for update
jason scott gessner 13:27 on 19 Jul 2004

Re: Select for update
Edward J. Sabol 14:16 on 19 Jul 2004

Re: Select for update
Perrin Harkins 14:22 on 19 Jul 2004

Re: Select for update
Edward J. Sabol 15:11 on 19 Jul 2004

RE: Select for update
Ian McDonald-ONLINE 16:08 on 19 Jul 2004

RE: Select for update
Perrin Harkins 16:55 on 19 Jul 2004

Generated at 11:35 on 01 Dec 2004 by mariachi v0.52