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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general