From 9399e3f7f5e85f41871d4e586b0582f697380c0b Mon Sep 17 00:00:00 2001 From: Alvaro Herrera Date: Tue, 10 Sep 2019 12:48:28 -0300 Subject: [PATCH v13 2/8] doc change --- doc/src/sgml/libpq.sgml | 26 ++++++++++++++++++-------- 1 file changed, 18 insertions(+), 8 deletions(-) diff --git a/doc/src/sgml/libpq.sgml b/doc/src/sgml/libpq.sgml index 5601485555..23bf1ea632 100644 --- a/doc/src/sgml/libpq.sgml +++ b/doc/src/sgml/libpq.sgml @@ -1647,17 +1647,27 @@ postgresql://%2Fvar%2Flib%2Fpostgresql/dbname target_session_attrs + + The supported options for this parameter are, any and + read-write. The default value of this parameter, + any, regards all connections as acceptable. + If multiple hosts were specified in the connection string, based on the + specified value, any remaining servers will be tried before confirming + succesful connection or failure. + + If this parameter is set to read-write, only a connection in which read-write transactions are accepted by default - is considered acceptable. The query - SHOW transaction_read_only will be sent upon any - successful connection; if it returns on, the connection - will be closed. If multiple hosts were specified in the connection - string, any remaining servers will be tried just as if the connection - attempt had failed. The default value of this parameter, - any, regards all connections as acceptable. - + is considered acceptable. + + + + To find out whether the server supports read-write transactions are not, + query SHOW transaction_read_only will be sent upon any + successful connection; if it returns on, it means server + doesn't support read-write transactions. + -- 2.17.1