From b260ce9c19b64e0430d89f8cc586fc8f6df5ee07 Mon Sep 17 00:00:00 2001 From: Etsuro Fujita Date: Fri, 8 Nov 2019 17:00:37 +0900 Subject: postgres_fdw: Fix error message for PREPARE TRANSACTION. Currently, postgres_fdw does not support preparing a remote transaction for two-phase commit even in the case where the remote transaction is read-only, but the old error message appeared to imply that that was not supported only if the remote transaction modified remote tables. Change the message so as to include the case where the remote transaction is read-only. Also fix a comment above the message. Also add a note about the lack of supporting PREPARE TRANSACTION to the postgres_fdw documentation. Reported-by: Gilles Darold Author: Gilles Darold and Etsuro Fujita Reviewed-by: Michael Paquier and Kyotaro Horiguchi Backpatch-through: 9.4 Discussion: https://postgr.es/m/08600ed3-3084-be70-65ba-279ab19618a5%40darold.net --- doc/src/sgml/postgres-fdw.sgml | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'doc/src') diff --git a/doc/src/sgml/postgres-fdw.sgml b/doc/src/sgml/postgres-fdw.sgml index 7c922821e98..48e0ad27563 100644 --- a/doc/src/sgml/postgres-fdw.sgml +++ b/doc/src/sgml/postgres-fdw.sgml @@ -415,6 +415,12 @@ COMMITTED local transaction. A future PostgreSQL release might modify these rules. + + + Note that it is currently not supported by + postgres_fdw to prepare the remote transaction for + two-phase commit. + -- cgit v1.2.3