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 1iCxlC-0001Ug-5e for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Sep 2019 03:14:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iCxlA-0000Cf-Vz for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Sep 2019 03:14:32 +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 1iCxlA-00005D-IY for pgsql-hackers@lists.postgresql.org; Wed, 25 Sep 2019 03:14:32 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1iCxl7-0004uS-Rv for pgsql-hackers@lists.postgresql.org; Wed, 25 Sep 2019 03:14:31 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id A89C822036; Tue, 24 Sep 2019 23:14:28 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Tue, 24 Sep 2019 23:14:28 -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=yxXIL00AtmwdGt74MDThtfSW9lq kyWq8QzhJs4Zdsrk=; b=YeJwE/ulGbmsvBkiWq/5N2HgGWOEnmlW+t5SYKqYBIB dUFSQX8coo/cOQJbtnvbfVTiQveodsZNsPrLv1tALZVjquOtipAOkihd7hjj8MYv D7/YoB58ysyQ2Od+O+1pGKZh030C9p/BE21x2jsjNAJAACspo5duGSsk1JArT+Kv RkTSA2fXNVRHwjZ64a0QtPtLBK4Mc2eADK92tUyO+fUcU+pDvQT4GZ1y/XatPuP6 DFJChChoQIcJQr4h6VAYJbwCxIjPHhfZJC8A11VC9AXplTBZ/F8cI2qns2LX7WX1 xkjvHTHvgAdfsyD05hXwRu3J8jDWFqXfaPFgxzKkmzg== 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=yxXIL0 0AtmwdGt74MDThtfSW9lqkyWq8QzhJs4Zdsrk=; b=QcfHOItUuln2tNu6cVNBz2 T82jzreV8XMPNVWBC47+3oMIggqsc9WVTgu3cgsM3Wz9D4JQIU7htGGq9HoADQct MBDw8XD98EHt1B1AbjCdAAY/MDVp0gry+qNgSQDIdw6WKfXpQGDXdJz8JzhJYNg9 OVxLUhQZmJ0mlI00neqF2c9XRZ3/EYe1mxk6XDcUy4PanxEU2x9a6yAPG+vAlGog pDlOqAqmmWSa0GaLORn4/gTZlRtQ13b/pSo9D2htkQVhLI29bCgNYKGB0Fn8Q98n zVykidsQ7A4x7G+GCKU2It4KVZZnO27tkSh6QI9ueMcy2Ad+q7kFfEl+/jq2wjdw == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedufedrfedugdeilecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdejtddmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttdej necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecukfhppeduuddurddutddvrddukedtrddukeehnecurfgrrhgr mhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiiinecuvehluh hsthgvrhfuihiivgeptd 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 64D99D6005B; Tue, 24 Sep 2019 23:14:08 -0400 (EDT) Date: Wed, 25 Sep 2019 12:13:55 +0900 From: Michael Paquier To: Alvaro Herrera Cc: Nikolay Shaplov , pgsql-hackers@lists.postgresql.org, Thomas Munro , Dent John , Tom Lane , Robert Haas Subject: Re: [PATCH] src/test/modules/dummy_index -- way to test reloptions from inside of access method Message-ID: <20190925031355.GD1815@paquier.xyz> References: <9629467.uHNm3GW8oi@x200m> <20190924153830.GA26314@alvherre.pgsql> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="tEFtbjk+mNEviIIX" Content-Disposition: inline In-Reply-To: <20190924153830.GA26314@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --tEFtbjk+mNEviIIX Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Sep 24, 2019 at 12:38:30PM -0300, Alvaro Herrera wrote: > On 2019-Sep-24, Nikolay Shaplov wrote: >> =D0=92 =D0=BF=D0=B8=D1=81=D1=8C=D0=BC=D0=B5 =D0=BE=D1=82 =D0=B2=D1=82=D0= =BE=D1=80=D0=BD=D0=B8=D0=BA, 24 =D1=81=D0=B5=D0=BD=D1=82=D1=8F=D0=B1=D1=80= =D1=8F 2019 =D0=B3. 9:25:54 MSK =D0=BF=D0=BE=D0=BB=D1=8C=D0=B7=D0=BE=D0=B2= =D0=B0=D1=82=D0=B5=D0=BB=D1=8C Alvaro=20 >> Herrera =D0=BD=D0=B0=D0=BF=D0=B8=D1=81=D0=B0=D0=BB: >>> 0003 looks useful, thanks for completing it. I think it would be a good >>> idea to test invalid values for each type of reloption too (passing >>> floating point to integers, strings to floating point, and so on). >>=20 >> We already do it in reloption regression tests. >>=20 >> My idea was to test here only the things that can't be tested in regress= ion=20 >> tests, on in real indexes like bloom. >=20 > I suppose that makes sense. But of course when I push enum reloptions > I will have to add such a test, since bloom does not have one. Good point. We rely now on the GUC parsing for reloptions, so having cross-checks about what patterns are allowed or not is a good idea for all reloption types. I have added all that, and committed the module. The amount of noise generated by the string validator routine was a bit annoying, so I have silenced them where they don't really matter (basically everything except the initial creation). -- Michael --tEFtbjk+mNEviIIX Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl2K23MACgkQnvQgOdby QH21jw/6AuFbA+P/UHTHohXhgVJacMqLbp59Sgal75CBCeyChq0tFxgViQTN+BK9 1rx6Q8Do5RU14rA+i14jujXfUAkWSaARljJ3/wd0DteLxigblm0uQ/e60Qp/CgVD j0CyyOPy8ALybo7P0GZwO0ankSW3d36E0O7Wv62VjV8zLN/r/l7VxBGjLv1KNlEj STgYL4V2nQE/kNNMbZ1AU+FiAgcT2hCUTib+ZbaxbCoBhoeGv6NTxYaU3J4NFTH/ 5D4hOxmxK7c77j7GmC1PWF7YUjxB4A7NzeYoEgbkRlKXoF2tRvxw4W88acXKz7kB BZUaoJwCmlPjvk0fTJZSrwIGQJZyHiUNOD2WZId3A7WRSEcMwT6pZkYCvDRYi1Le NWA3BIvl607tBGAiKhI7yZ8Lwv7nmN5W5J60C+UfYZCXPZQhpGNZdmUMg6D2UWKP 2yPknUm835+w7PEGe1OdBaqX2rb/q3xcqotnwRHsVkIy/oiA9lKo+AnBt6HvAJRw 5d1PvPYYRVHFWsaav5ltyUmtatbNbloaecj6xv/38dLJMoNvcncnBox9Vwra/G5t XnSuyOvw8d+/QzayByZZVbfk2tDDx0h6BNa2nv1qxYlWHMgO6UiE8eYbW1OfoZna DhAOgCHm3nAbGmuSDbiZfvNTzQGkVPP4nddky3TNKjEcWcYqIuc= =K3wA -----END PGP SIGNATURE----- --tEFtbjk+mNEviIIX--