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