Skip to content

Commit ee79a54

Browse files
committed
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
1 parent ed43677 commit ee79a54

File tree

1 file changed

+3
-1
lines changed

1 file changed

+3
-1
lines changed

doc/src/sgml/postgres-fdw.sgml

+3-1
Original file line numberDiff line numberDiff line change
@@ -493,7 +493,9 @@ OPTIONS (ADD password_required 'false');
493493
each connection is valid or not. <literal>false</literal> is returned
494494
if the foreign server connection is used in the current local
495495
transaction but its foreign server or user mapping is changed or
496-
dropped, and then such invalid connection will be closed at
496+
dropped (Note that server name of an invalid connection will be
497+
<literal>NULL</literal> if the server is dropped),
498+
and then such invalid connection will be closed at
497499
the end of that transaction. <literal>true</literal> is returned
498500
otherwise. If there are no open connections, no record is returned.
499501
Example usage of the function:

0 commit comments

Comments
 (0)