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 1h39TS-0003B3-VC for pgsql-committers@arkaria.postgresql.org; Mon, 11 Mar 2019 01:11:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h39TR-00081J-Ng for pgsql-committers@arkaria.postgresql.org; Mon, 11 Mar 2019 01:11:25 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h39TP-0007xX-Sh for pgsql-committers@lists.postgresql.org; Mon, 11 Mar 2019 01:11:25 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h39TM-0000St-R3 for pgsql-committers@lists.postgresql.org; Mon, 11 Mar 2019 01:11:22 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id B545521C86; Sun, 10 Mar 2019 21:11:19 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Sun, 10 Mar 2019 21:11:19 -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=fm1; bh=afA3o2igBg9mk0lDR1DGiFftW8w yZlVnJ0C3Pq635z4=; b=nXBaExWTRy1t+PP53fe7SqF5UO9QfN2dOFCURY02zYn 3QsFYDI7YZhUVzbm8yR4dlf2OXhhf3qmSDpGjCw0Uh1CQYV//pmmeYZLJzjXfOpy Hnp9yTgKTPv8ZYw/PSA/13IukG6aAl2GP5Ra/CTjMD1aIw4v9JBTlM15DwizkxzU WFNclyeQ7sKqTDEQrfGLPI6HxbP3dZ0RU3uDG6t2RN1Q/JGZZhtCb+OfpD+1/SZ/ 6YY5/rLQxzEsmg5KY5Y0CreyfHGmmy+FkRctQ09NcGutmRVEKH1TKwNJeNWQ+2nF wYbTh9B9+itkM0ey5eMS6fTdU20J2VfVx+CDyGcR4Jg== 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=fm2; bh=afA3o2 igBg9mk0lDR1DGiFftW8wyZlVnJ0C3Pq635z4=; b=2xSh3cblk7bnY2yhORfZMc iVQXPveDTAUpkRil5yXYN3jpwKw96Yd6x621V6f8vq71ek4/eEU7j/wRDpGydsVP PQjWhHTHlPEIySJQ0afLGLzLtm2GhL0kfBwcjTQncYxFd9LjTEz/m4xgy+CYfwRc vUjrSCXsR2dfAyEtZyZGaoKdK9daVPA4/R3HRILcuCHIJQn1LITgjrsAK6c0yvW3 AZ/ov3ciOceE9OCGFDBTWv7eUT9CrSzsgXaAm5SPwF0KFSVvZ/5F150g3O/fqvHM 5gD/KTp0AuAZNiw14oOImJVrQDJHn05GSRUBc/gtPUSblnndHiSlyxOYG/Qu56NA == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedutddrgeehgdeftdcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecufghrlhcuvffnffculdefhedmnecujfgurhepfffhvf fukfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhi vghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuffhomhgrihhnpehpoh hsthhgrhgvshhqlhdrohhrghenucfkphepiedurddvudehrddufeejrdduiedvnecurfgr rhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiiinecuve hluhhsthgvrhfuihiivgeptd X-ME-Proxy: Received: from paquier.xyz (c137162.net61215.cablenet.ne.jp [61.215.137.162]) by mail.messagingengine.com (Postfix) with ESMTPA id B76DDE4546; Sun, 10 Mar 2019 21:11:17 -0400 (EDT) Date: Mon, 11 Mar 2019 10:11:14 +0900 From: Michael Paquier To: Tom Lane Cc: pgsql-committers@lists.postgresql.org Subject: Re: pgsql: Include GUC's unit, if it has one, in out-of-range error message Message-ID: <20190311011114.GD1818@paquier.xyz> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="oj4kGyHlBMXGt3Le" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --oj4kGyHlBMXGt3Le Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Sun, Mar 10, 2019 at 07:18:20PM +0000, Tom Lane wrote: > Include GUC's unit, if it has one, in out-of-range error messages. >=20 > This should reduce confusion in cases where we've applied a units > conversion, so that the number being reported (and the quoted range > limits) are in some other units than what the user gave in the > setting we're rejecting. >=20 > Some of the changes here assume that float GUCs can have units, > which isn't true just yet, but will be shortly. It does not seem to have cooled down all animals yet, whelk is still complaining: https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=3Dwhelk&dt=3D2019-0= 3-11%2000%3A41%3A13 -ERROR: -Infinity is outside the valid range for parameter "geqo_selection= _bias" (1.5 .. 2) +ERROR: invalid value for parameter "geqo_selection_bias": "-infinity" It would be nice if we could avoid an alternate output. -- Michael --oj4kGyHlBMXGt3Le Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlyFtbIACgkQnvQgOdby QH2CPg//Uz3lEZR+rbcu3HEivG4KlVFLPw8oFSvuTEXw/B299PD3kPYs+FsGmCww IrbqRchBS6U6xcJspHlyEkn/WvOk+tGgDAkwtYWwCq5RP4YMaPSLx5bH2rrRf9VT 0EQDZIUABcn7755H5wsLLGy3yPHBBZzvQT/T5uQ8TrVxCFG0zs9H3bqGr5kx5XZj sM01tjGcZvZKLJ6N2DliidzQqUjBk/GvbymJCAkfbZ1poo/4sT9JSy28dER+tvYg PcoNPjicjXgWYPkLlAh8G9QOqEbNnWmSDk0vpomCiNiKxnoGtPygmR29QBFZQdzm kuCVbSQajphBgGDTJ+F/CteA6VTss8KLDAXQ961nTchFod3FCN1AHuILHsa43Few AVxPNnxDiLW1d+7h4JyNrYaErMRWRxyhWQNgS+UmE9jQh0u25Hykf20Na/ASCDlL /tA7Ac3M27p1uewP4pIFfvg6W/8ORdVTV2zRM8Roi5OLheSL9KaBn/y8d2PlI9CX mZqmJciSCdzrqln5Hs3fSIYObUzKXdWkpnXqh/yzFITxTBLREEpz8wRFzoBVj0DK sBtNp9WaETDfabuDShQGVQSJPN9Yy9UYVMJrpEyrPCLBnamPI1IA5U9WPwb+Gyz6 nLJKUsYkKVjIVzvej3dfpSf/FzlPNfypYmZ7sh6Vfkgf7N/hK1E= =fMii -----END PGP SIGNATURE----- --oj4kGyHlBMXGt3Le--