Take this update statement:
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? I am assumed that foo will always be correct and that the database will manage any contention, but when I think about transaction isolation, I'm not so sure. Is it possible for two or more instances of this update to run simultaneously, each getting the same value for foo, then each updating foo to the same incremented value? Is this a stupid question? ---------------------------(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
