Re: synchronized snapshots

On Sun, Aug 14, 2011 at 9:31 PM, Joachim Wieland <joe@mcknight.de> wrote:
> This is a patch to implement synchronized snapshots. It is based on
> Alvaro's specifications in:
>
> http://archives.postgresql.org/pgsql-hackers/2011-02/msg02074.php

Here is a new version of this patch, what has changed is that the
snapshot is now imported via:

BEGIN
[... set serializable or read committed on the BEGIN or via SET TRANSACTION ...]
SET TRANSACTION SNAPSHOT '00000801-1'

This way any failure importing the snapshot leaves the transaction in
the aborted state.

I am also attaching a small perl script that demonstrates a
serialization failure with an imported snapshot.

This is the link to the previous patch:
http://archives.postgresql.org/pgsql-hackers/2011-08/msg00684.php


Joachim