From ee79a548e746da9a99df0cac70a3ddc095f2829a Mon Sep 17 00:00:00 2001
From: Fujii Masao
Date: Tue, 19 Jan 2021 00:56:10 +0900
Subject: doc: Add note about the server name of postgres_fdw_get_connections()
returns.
Previously the document didn't mention the case where
postgres_fdw_get_connections() returns NULL in server_name column.
Users might be confused about why NULL was returned.
This commit adds the note that, in postgres_fdw_get_connections(),
the server name of an invalid connection will be NULL if the server is dropped.
Suggested-by: Zhijie Hou
Author: Bharath Rupireddy
Reviewed-by: Zhijie Hou, Fujii Masao
Discussion: https://postgr.es/m/e7ddd14e96444fce88e47a709c196537@G08CNEXMBPEKD05.g08.fujitsu.local
---
doc/src/sgml/postgres-fdw.sgml | 4 +++-
1 file changed, 3 insertions(+), 1 deletion(-)
diff --git a/doc/src/sgml/postgres-fdw.sgml b/doc/src/sgml/postgres-fdw.sgml
index 6a91926da83..9adc8d12a9d 100644
--- a/doc/src/sgml/postgres-fdw.sgml
+++ b/doc/src/sgml/postgres-fdw.sgml
@@ -493,7 +493,9 @@ OPTIONS (ADD password_required 'false');
each connection is valid or not. false is returned
if the foreign server connection is used in the current local
transaction but its foreign server or user mapping is changed or
- dropped, and then such invalid connection will be closed at
+ dropped (Note that server name of an invalid connection will be
+ NULL if the server is dropped),
+ and then such invalid connection will be closed at
the end of that transaction. true is returned
otherwise. If there are no open connections, no record is returned.
Example usage of the function:
--
cgit v1.2.3