From bb446b689b6681eb57a8a50605e119743190c4db Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sat, 22 Oct 2011 18:22:45 -0400 Subject: Support synchronization of snapshots through an export/import procedure. A transaction can export a snapshot with pg_export_snapshot(), and then others can import it with SET TRANSACTION SNAPSHOT. The data does not leave the server so there are not security issues. A snapshot can only be imported while the exporting transaction is still running, and there are some other restrictions. I'm not totally convinced that we've covered all the bases for SSI (true serializable) mode, but it works fine for lesser isolation modes. Joachim Wieland, reviewed by Marko Tiikkaja, and rather heavily modified by Tom Lane --- src/include/parser/kwlist.h | 1 + 1 file changed, 1 insertion(+) (limited to 'src/include/parser') diff --git a/src/include/parser/kwlist.h b/src/include/parser/kwlist.h index 12c2faf3de8..3d170bc3679 100644 --- a/src/include/parser/kwlist.h +++ b/src/include/parser/kwlist.h @@ -337,6 +337,7 @@ PG_KEYWORD("show", SHOW, UNRESERVED_KEYWORD) PG_KEYWORD("similar", SIMILAR, TYPE_FUNC_NAME_KEYWORD) PG_KEYWORD("simple", SIMPLE, UNRESERVED_KEYWORD) PG_KEYWORD("smallint", SMALLINT, COL_NAME_KEYWORD) +PG_KEYWORD("snapshot", SNAPSHOT, UNRESERVED_KEYWORD) PG_KEYWORD("some", SOME, RESERVED_KEYWORD) PG_KEYWORD("stable", STABLE, UNRESERVED_KEYWORD) PG_KEYWORD("standalone", STANDALONE_P, UNRESERVED_KEYWORD) -- cgit v1.2.3