On Tue, 2008-05-20 at 17:04 -0400, Andrew Sullivan wrote: > On Tue, May 20, 2008 at 08:56:41PM +0200, Ivan Sergio Borgonovo wrote: > > > I just would like to have a coherent snapshot of some tables. > > If you have a multi-statement transaction, then if you are in READ > COMMITTED you can see changes, and if you are in SERIALIZABLE you > can't. Unless the changes were made by yourself in the top-level transaction or an un-aborted subtransaction, in which case they are visible. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support
