Michael Fuhr <mike@xxxxxxxx> writes: > On Thu, Feb 10, 2005 at 09:53:49AM -0500, Tom Lane wrote: >> xactC: starts, sets snapshot > Hmmm...that's not what I'm seeing in 8.0.1, at least not when > xactC is READ COMMITTED: Remember RC mode takes a new snapshot for each query. You'd need to use serializable mode --- and do something to actually freeze the transaction snapshot, which BEGIN does not --- to see the issue in a manual test. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq