Re: [GENERAL] Implicit row locking during an UPDATE

2001-05-25 Thread Eric G. Miller
On Fri, May 25, 2001 at 02:23:50AM -, Dr. Evil wrote: > > I'm still not understanding this, and it's vitally important to the > project I'm working on, so I have a question: > > >From my understanding, this: > > UPDATE account SET value = 10 WHERE number = 99; > > actually implies all of t

Re: [GENERAL] Implicit row locking during an UPDATE

2001-05-24 Thread Tom Lane
"Dr. Evil" <[EMAIL PROTECTED]> writes: > From my understanding, this: > UPDATE account SET value = 10 WHERE number = 99; > actually implies all of this: > BEGIN; > SELECT value FOR UPDATE FROM account WHERE number = 99; > UPDATE account SET value = 10 WHERE number = 99; > COMMIT; > END; Not re