Re: synchronized snapshots - Mailing list pgsql-hackers

From Joachim Wieland
Subject Re: synchronized snapshots
Date
Msg-id CACw0+12Fh11NnUpa+S3mLPcNOiJtQMUY2_H=RHVDMoN7AYPJ+A@mail.gmail.com
Whole thread Raw
In response to Re: synchronized snapshots  (Marko Tiikkaja <marko.tiikkaja@2ndquadrant.com>)
List pgsql-hackers
Hi Marko,

On Wed, Sep 28, 2011 at 2:29 AM, Marko Tiikkaja
<marko.tiikkaja@2ndquadrant.com> wrote:
> In a sequence such as this:
>
>  BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE;
>  INSERT INTO foo VALUES (-1);
>  SELECT pg_export_snapshot();
>
> the row added to "foo" is not visible in the exported snapshot.  If that's
> the desired behaviour, I think it should be mentioned in the documentation.

Yes, that's the desired behaviour, the patch add this paragraph to the
documentation already:

"Also note that even after the synchronization both clients still run
their own independent transactions. As a consequence, even though
synchronized with respect to reading pre-existing data, both
transactions won't be able to see each other's uncommitted data."

I'll take a look at the other issues and update the patch either
tonight or tomorrow.


Thank you,
Joachim


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: fix for pg_upgrade
Next
From: Jamie Fox
Date:
Subject: Re: Mismatch of relation names: pg_toast.pg_toast_nnn during pg_upgrade from 8.4 to 9.1