From cf652018332819716b10c9de9ce80c81284d6815 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Wed, 2 Aug 2017 10:59:01 -0400 Subject: [PATCH] Get a snapshot before COPY in table sync This fixes a crash if the local table has a function index and the function makes non-immutable calls. Reported-by: Scott Milliken Author: Masahiko Sawada --- src/backend/replication/logical/tablesync.c | 2 ++ 1 file changed, 2 insertions(+) diff --git a/src/backend/replication/logical/tablesync.c b/src/backend/replication/logical/tablesync.c index 32abf5b368..4cca0f1a85 100644 --- a/src/backend/replication/logical/tablesync.c +++ b/src/backend/replication/logical/tablesync.c @@ -917,7 +917,9 @@ LogicalRepSyncTableStart(XLogRecPtr *origin_startpos) walrcv_create_slot(wrconn, slotname, true, CRS_USE_SNAPSHOT, origin_startpos); + PushActiveSnapshot(GetTransactionSnapshot()); copy_table(rel); + PopActiveSnapshot(); res = walrcv_exec(wrconn, "COMMIT", 0, NULL); if (res->status != WALRCV_OK_COMMAND) -- 2.40.0