Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hqsJf-0001ob-TA for pgsql-bugs@arkaria.postgresql.org; Fri, 26 Jul 2019 04:58:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hqsJc-0006Yj-R3 for pgsql-bugs@arkaria.postgresql.org; Fri, 26 Jul 2019 04:58:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hqsJb-0006YW-3G for pgsql-bugs@lists.postgresql.org; Fri, 26 Jul 2019 04:58:48 +0000 Received: from [64.147.123.20] (helo=wout4-smtp.messagingengine.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hqsJR-0001YM-LF for pgsql-bugs@lists.postgresql.org; Fri, 26 Jul 2019 04:58:45 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id D7A7B540; Fri, 26 Jul 2019 00:58:14 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Fri, 26 Jul 2019 00:58:15 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm2; bh=het32tVyw4EwTOefSsyEUJJ4zu+ zOpZR6PEIiGypnYo=; b=FoP93d1X4P8w1CIWoHyRSe8Xe/I8fmCMH/qEqRBtaJM a4/Sgkt28gXyoQrPofCPLmAopfVZUGPmodUkgb49dkPdrV3OS2LtCxkY8EZVECjA ku8RD8u+UHHhUV5/pDGPNZzeaVfRcXPHBvn86n+cmL3c0aV4PUFLLJqJciKrTw16 1bB5wHzVETdTX1Sgqvpv0WVYRlhGNWQgteBaJnBLFidGyPXyG1TcgVCdc1BRGuL4 2YCo0BRq5AiskNUAieFJKZpIZ6ACxwsvF8yJHwxRVpxmFoz2Ls/gHxUejAh0apOL X13gf5VWQ40uPsJRrrUlqWqiV4PkYcl/WkLZ3up5FDg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=het32t Vyw4EwTOefSsyEUJJ4zu+zOpZR6PEIiGypnYo=; b=P81kzVRmlbHyTcTDYMX0jR yh0O5S2PNy9HN8kIOJAOjLfjssh+ITec5TviHHmDVtXIlTVV6WMKYuR5qIXoP1MQ 7i89oP7uvNFW345HvM+ZOtlF1+bYkt94Hz53Sb0sZNWzexeX3wy+m0aXYMZlq/HS ihKrOQtvNo4l1FIWw2hcgea1llfXobLcOc3wu6xFG4RIJfEu+DF6iORzBLhQAqz4 zss08pBZlFK4E7A246PbVjfjrD9Ce6m0yu4J/BAz52KgQAXkgPO4UxWt1qZ3ssGV PvvLFjpAB6fId59wMIiqjoNlhVPdPNejVoO1B58dGeScDkgek3AhgGjD+LtRmucA == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduvddrkeefgdeklecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecufghrlhcuvffnffculdejtddmnecujfgurhepfffhvf fukfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhi vghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecukfhppeduuddurddutd dvrddukedtrddukeehnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehp rghquhhivghrrdighiiinecuvehluhhsthgvrhfuihiivgeptd X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id 4B20980059; Fri, 26 Jul 2019 00:58:11 -0400 (EDT) Date: Fri, 26 Jul 2019 13:58:08 +0900 From: Michael Paquier To: Tom Lane Cc: Jorge Gustavo Rocha , pgsql-bugs@lists.postgresql.org Subject: Re: BUG #15827: Unable to connect on Windows using pg_services.conf using Python psycopg2 Message-ID: <20190726045808.GF7677@paquier.xyz> References: <23215.1560977098@sss.pgh.pa.us> <20190620031218.GC2660@paquier.xyz> <20190620070319.GH2660@paquier.xyz> <0a9fcd30-5ae2-7e5f-ac1d-60d14a2ebb63@geomaster.pt> <20190621004233.GA1626@paquier.xyz> <3383.1561078113@sss.pgh.pa.us> <25605.1561652435@sss.pgh.pa.us> <20190628031056.GA1797@paquier.xyz> <5805.1561750411@sss.pgh.pa.us> <29487.1564071212@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="Bg2esWel0ueIH/G/" Content-Disposition: inline In-Reply-To: <29487.1564071212@sss.pgh.pa.us> X-Host-Lookup-Failed: Reverse DNS lookup failed for 64.147.123.20 (deferred) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Bg2esWel0ueIH/G/ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thu, Jul 25, 2019 at 12:13:32PM -0400, Tom Lane wrote: > Hearing nothing further on this, I went ahead with the patch as I had it > on HEAD, and a tweaked version of your patch on the back branches. Thanks Tom for taking care of that stuff. Coming late at the party, I have one comment post-commit. Perhaps we could have a wrapper in charge of doing this work in with something adding properly \0 at the end of those strings for CR and LF and returning the new length after adjustment, like pg_strip_clrf in common/string.c? There are nine places changed on HEAD. -- Michael --Bg2esWel0ueIH/G/ Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl06iGAACgkQnvQgOdby QH3Iww//RJgoXNbwBAUNdV1yPNGm2dolB1b5dvKIk96nL9OnvqbSsS5LTtH/AQ5K s+lmT9nLRgQ4HouUPYS8rbqwxe94hf35Vi54s7bpFCWAfhJj9K+ZBsbF6XLyeAV6 xKe/ZutzTlWY9OtFNMvxxBXrEfuu/RRGJ9oKnpYA7ca64YGGfyZKzKdfY8ZIfrw4 1+egh4eVFxEMJ5ndqSXqG8YaOoSf+l8/J1E8et7Murt6lCI6BASI2k5W5cXf7lUf koaGF62EpcgG3U29EIBbXTm6BQdYIbaX9SrkkV10PaXz8rd5JPhn24coxtSwYFyL g/a/GNNG07R0wClnAEqIEl+yDQ7Jm574mfBgfiJfkIU3/YCARXSEzAqPu1ZG2tUF H9c2z36w44Au16GiI4km5YUY8b4+Yh8/PEJrqPWQ6dX5ktr9aXiDFZTs3UDQKBqj Eod4V446SbZl71TQdC6ZuHu8WzyEX/0Oy5rxslUjjUOzGCMKCI9HnQwkISssz0Ca PYRdG6XYsiKqJjik38qUDL6b8aCSecg6vdU2231LrNTRx/2efUPKLFs6giF2tsUA CTHBDtSPsFGt8h6um+OaC3XxdK8uH4mgIVlJkq5vz7wkapMFxwl/5oyF289SZzFW cUCgNNAFuYzE17V7AVMo8vRYCxLktVP8vvm/U1VGteWOivt7C3U= =Z9Fl -----END PGP SIGNATURE----- --Bg2esWel0ueIH/G/--