From: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-hackers@lists.postgresql.org
Subject: Very misleading documentation for PQreset()
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1095900.1611268376.1@sss.pgh.pa.us>
Date: Thu, 21 Jan 2021 17:32:56 -0500
Message-ID: <1095901.1611268376@sss.pgh.pa.us>
Precedence: bulk

I happened to notice that PQreset is documented thus:

    This function will close the connection to the server and attempt to
    reestablish a new connection to the same server, using all the same
    parameters previously used.

Since we invented multi-host connection parameters, a reasonable person
would assume that "to the same server" means we promise to reconnect to
the same host we selected the first time.  There is no such guarantee
though; the new connection attempt is done just like the first one,
so it will select the first suitable server in the list.

I think we should just drop that phrase.  Alternatively we could decide
that the code's behavior is buggy, but I don't think it is.  If, say,
the reason you need to reset is that your existing host died, you don't
really want libpq to refuse to select an alternative server.

			regards, tom lane