Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgresql MVCC, Read Committed Isolation Level and taking "snapshot" - Mailing list pgsql-general

From Simon Riggs
Subject Re: Postgresql MVCC, Read Committed Isolation Level and taking "snapshot"
Date
Msg-id 1211334703.4082.17.camel@ebony.site
Whole thread Raw
In response to Re: Postgresql MVCC, Read Committed Isolation Level and taking "snapshot"  (Andrew Sullivan <ajs@commandprompt.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Vlad Kosilov
Date:
Subject: Re: pg_standby stuck on a wal file size <16MB
Next
From: "Gurjeet Singh"
Date:
Subject: Re: pg_standby stuck on a wal file size <16MB