On Dec 1, 2010, at 11:09 AM, Florian Pflug wrote:
> An UPDATE on such a SHARE locked row would be allowed despite the lock if it only changed columns not mentioned by
anyunique index.
On a side-note, by "changed columns" do you mean the column appeared in the UPDATE statement, or the data actually
changed?I suspect the former might be easier to implement, but it's really going to fsck with some applications (Rails
isone example that comes to mind).
--
Jim C. Nasby, Database Architect jim@nasby.net
512.569.9461 (cell) http://jim.nasby.net