"Joshua D. Drake" <j...@commandprompt.com> writes: > What is needed here is a layman's context of what isolation modes are > good for what type of operation. Neither your explanation or Tom's is > particularly useful except to say, "Crap, I might be screwed but I don't > know if I am... how do I find out?"
If we had a simple way to characterize that, we'd not be having this discussion :-( One possibility is to try to list the risky cases. So far I can think of: * updates using a WHERE clause that tests columns being changed by other transactions * updates using subqueries/joins so that the result depends on other rows besides the one directly updated/deleted, and those other rows are subject to concurrent changes But I'm not sure this is a complete list, and an incomplete one might do more harm than good ... regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers