On Monday, August 15, 2011 08:40:34 Simon Riggs wrote: > On Mon, Aug 15, 2011 at 2:31 AM, Joachim Wieland <j...@mcknight.de> wrote: > > In short, this is how it works: > > > > SELECT pg_export_snapshot(); > > pg_export_snapshot > > -------------------- > > 000003A1-1 > > (1 row) > > > > > > (and then in a different session) > > > > BEGIN TRANSACTION ISOLATION LEVEL REPEATABLE READ (SNAPSHOT = > > '000003A1-1'); > I don't see the need to change the BEGIN command, which is SQL > Standard. We don't normally do that. Uhm. There already are several extensions to begin transaction. Like the just added "DEFERRABLE".
> If we have pg_export_snapshot() why not pg_import_snapshot() as well? Using BEGIN has the advantage of making it explicit that it cannot be used inside an existing transaction. Which I do find advantageous. Andres -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
