Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qyK5n-007cx3-9X for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Nov 2023 22:53:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qyK5l-009QjQ-T9 for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Nov 2023 22:53:41 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qyK5l-009QjI-JY for pgsql-hackers@lists.postgresql.org; Wed, 01 Nov 2023 22:53:41 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qyK5g-003Vqi-0P for pgsql-hackers@lists.postgresql.org; Wed, 01 Nov 2023 22:53:40 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id 6B96F5C0358; Wed, 1 Nov 2023 18:53:35 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute2.internal (MEProxy); Wed, 01 Nov 2023 18:53:35 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:sender :subject:subject:to:to; s=fm3; t=1698879215; x=1698965615; bh=xG 77pdAgdwTEQyAHO75wYKG9yOVRiLe63ICSoIOK5J0=; b=HmYJAP6jhBK/4/9Lxa O9l8KEMbsj79S6vQFbATBG8u4YpAi3GYS48ATAEDhvvU3JfWGioi1o8yRYp8TT+s QjAULQ4MPAATLp6jCLS5kP81TMy6elh22nMMO9ywtXcTeF8qc5U6b2eRy6iKpPJ1 VMzpG5bpHXS8ONrBQVPuXOWRe9KMpr+lR4g9QBpSvuKzRSMRE60UgzKXsXqZ8fU+ gTMOl21XhbzjOCQuOvYWdulwviH14SEhQNifeke/jAJSpIgutOG/kEODiDPv2f3v MTqYNHi0FU8dwNdbMfNUFZ6lM0gVbxxHeGygV7OrITTKvRd+apHP0hTHF+v5pJpp 3sqQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm3; t=1698879215; x=1698965615; bh=xG77pdAgdwTEQ yAHO75wYKG9yOVRiLe63ICSoIOK5J0=; b=HpNxijlGQhMj7xr5Ov6cOH9sK+/il +DufBmaSrkuPo0tHeUHbLgjTlTKUx0hr+gZABARogNHFxNsCyXGgK661g4TJo6Yn bNk9Yx5edEc5tDD6A76aGCMtn9U0t6MEh6KP29P+gPme7yLfU4y4a6hvxl54ErZz oQTQSdDNnfxenfkZUYBzuiJJPf0G7Hsm4r3cHdlLX2Lq4Y//hcwnGg/fw9gANHBt tXshTM/ZD8OnmGriJXo4DbQ9ccyTYzTTVEZxHoEB2HY42uFi3hvPxu+T9U8PdkNH 9A9XAa8p8Kqm2peABBCP6O9eTG4U1yXEQeAeKEuF6bNyR1a+wIdkmGQSg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedruddthedgtdefucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredt tddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesph grqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepteelieefudffhffhtdetleeg geegfffhkeeuveetiefgudduvedutefggeeivdejnecuvehluhhsthgvrhfuihiivgeptd enucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiih ii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 1 Nov 2023 18:53:33 -0400 (EDT) Date: Thu, 2 Nov 2023 07:53:18 +0900 From: Michael Paquier To: "Anton A. Melnikov" Cc: PostgreSQL Hackers Subject: Re: 003_check_guc.pl crashes if some extensions were loaded. Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="mG5MOrJXlIa/M/3P" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --mG5MOrJXlIa/M/3P Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thu, Nov 02, 2023 at 12:28:05AM +0300, Anton A. Melnikov wrote: > Found that src/test/modules/test_misc/t/003_check_guc.pl will crash if an extension > that adds own GUCs was loaded into memory. > So it is now impossible to run a check-world with loaded extension libraries. Right. That's annoying, so let's fix it. > --- a/src/test/modules/test_misc/t/003_check_guc.pl > +++ b/src/test/modules/test_misc/t/003_check_guc.pl > @@ -19,7 +19,7 @@ my $all_params = $node->safe_psql( > "SELECT name > FROM pg_settings > WHERE NOT 'NOT_IN_SAMPLE' = ANY (pg_settings_get_flags(name)) AND > - name <> 'config_file' > + name <> 'config_file' AND name NOT LIKE '%.%' > ORDER BY 1"); Wouldn't it be better to add a qual as of "category <> 'Customized Options'"? That's something arbitrarily assigned for all custom GUCs and we are sure that none of them will exist in postgresql.conf.sample. There's also no guarantee that out-of-core custom GUCs will include a dot in their name (even if I know that maintainers close to the community adopt this convention and are rather careful about that). -- Michael --mG5MOrJXlIa/M/3P Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmVC1t4ACgkQnvQgOdby QH0qIg/9GB6/8Sja/OsLUsimg2R3xRLEIbiQtd/AIocDGwlqXgYomwC2xcIpYS7m tzVWYqb9hVqrRHFYG+YU3TT3fe8QyJclBkmuDYumYmPZhQf66kO49aVZvxzFkgLR Mz/K6yYm733yjxBjbICsrLC8rFdbvLjZV3HmJ8+boqZFSqTElxwnTxkBCCx/9qjd ze3Bd1bIHxAZjGGZuvqE9No+7dw8oKVqLBIr7AFH/FOJ3AQFsW5+lKfFC7+Do5mP 6ABRudrVwiHohSHzO/7oQjJ7rTcLS0NVuBYrO7mEqgeEjxrLP0lI4MRMSzJ4byfH xSM1TSI6X0cObQORWX7pSL7XhnZwfa8p0/bfuGo8LqAhor/eJlPz11qel6Y88BUx Jjg91ccz1qSoRw6EfSbqUVjiISMj6gMFwKX06WZeVkXZnDzfI8WOvm1nxGl3GZVm ueghXoyJM1ohC0JUxfuH7+A7hQtIHurGEmMYrtz3d8VlqVNntgnIlP9v6FDDzBw1 5SEj4uIDHN3AwvenzNb3AYTIZmHTS8WtBi9nbEyPfeH8eFrffjjdsQtB3k6RaMP7 qMlEUwHqJQZ0YzAfK8O6nTzJG0tMY34R+zOrc1Ldyp1UUJFkfHyrDyGOefxvl+gB FaCrgUEL9hskCrdC8FK5jw/9Aaryuu3tUEhFyP/5dWtFf3i26iw= =xRrn -----END PGP SIGNATURE----- --mG5MOrJXlIa/M/3P--