mlw writes: > update mytable set foo=foo+1 where bar='xxx'; > > If that gets executed more than once at the same time by multiple instances of > postgresql. Will foo ever lose a count?
No, but if you run this in read committed isolation mode then you might get into non-repeatable read type problems, i.e., you run it twice but every foo was only increased once. If you use serializable mode then all but one concurrent update will be aborted. -- Peter Eisentraut [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
