Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l5M79-0002wM-Mi for pgsql-docs@arkaria.postgresql.org; Fri, 29 Jan 2021 05:14:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l5M78-0008Ce-KF for pgsql-docs@arkaria.postgresql.org; Fri, 29 Jan 2021 05:14:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l5M78-0008CT-EV for pgsql-docs@lists.postgresql.org; Fri, 29 Jan 2021 05:14:34 +0000 Received: from [66.111.4.28] (helo=out4-smtp.messagingengine.com) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l5M75-0001Jq-U7 for pgsql-docs@lists.postgresql.org; Fri, 29 Jan 2021 05:14:34 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.nyi.internal (Postfix) with ESMTP id 6045D5C018C; Fri, 29 Jan 2021 00:14:20 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute1.internal (MEProxy); Fri, 29 Jan 2021 00:14:20 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=XCoLaH9gasbwk0GBYe/ijxP0aUt Dp/9TJT+0L1gNktw=; b=HL7Txux/5YwCidsIwrWYHrxv7chsrDeWtGKECMUeAcG 3QShT6Wiv4J/qj/XZ80kzEdGIpSJ5N7h0HGTrlVLrAYXrvkv51Twi7SCBZ+zNUW6 yU5WtODhTsMrPRgypLwXMsNhe/KvREl0iyoSdMM/YRDnwDrSfBKV1ZzLGQ9d2mGq ztiPzRjgpZ7MiPVGWtsab7apYoDpBjGrGZvUaPvXtytc5knr2uz421Mil7NUbxuz 6bMemnjKEcm1oiCC8E7+vHn5FJfrxL9WvjBBr5U5Qg2HoMpJqJ787bjpgV1JGEsl iDfhp3UiXOWI94V5ucCWdmmwLBIKgDxjoFhoVfkxM2g== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=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=fm1; bh=XCoLaH 9gasbwk0GBYe/ijxP0aUtDp/9TJT+0L1gNktw=; b=IXKGZhJIrluC/FZBwNO1xI ps8NN42qMysaygiOj5cLxo/XtYxKKrgUD82iEp2uzdw/a+D7K31URzL754bQO5E+ T+HN7Fe1wg9cVA9O3JXG9ObpuNOHdSVKPeREZRKwDtg1BZmlGLV6iJVJbi9HOMgV xk0S+siIYSEd5W50aIgSraEVdiBmk5C/e0bZgVPwCNdGCOMyIFKaTwKp0qQrf6Jd Jl6QHf9Go6pzcZCP6uBJdxMQV8naiRoaXzIM0PJhnB8pqhbr3wN8J3Um3KKXj504 9V6ugESG/4Jl3AMnxq8Aq/x1duxdRuGRxoWYKA4N6sscI/HKUCL0hgdpApL/Mkag == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrfedugdejjecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecufghrlhcuvffnffculdefhedmnecujfgurhepfffhvf fukfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhi vghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnh epffdufeeflefghfekudekkeevvddugfeiteekkeduleefvefhhffftdduffeiuedtnecu ffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghenucfkphepudduuddruddtvddrud ektddrudekheenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhr ohhmpehmihgthhgrvghlsehprghquhhivghrrdighiii 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 0FBA124005B; Fri, 29 Jan 2021 00:14:18 -0500 (EST) Date: Fri, 29 Jan 2021 14:14:15 +0900 From: Michael Paquier To: joao.miguel.c.ferreira@gmail.com, pgsql-docs@lists.postgresql.org Subject: Re: is_local parameter on set_config function Message-ID: References: <161183356250.4077.687338658090583892@wrigleys.postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="LOFa/7p01oE5IkZH" Content-Disposition: inline In-Reply-To: <161183356250.4077.687338658090583892@wrigleys.postgresql.org> X-Host-Lookup-Failed: Reverse DNS lookup failed for 66.111.4.28 (deferred) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --LOFa/7p01oE5IkZH Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thu, Jan 28, 2021 at 11:32:42AM +0000, PG Doc comments form wrote: > I have just used the set_config(...) function for the first time and it took > me a bit of experimenting to understand the effect of the is_local > parameter. My suggestion would be to add a bit of explanation on that. This is equivalent to the LOCAL clause in the SET query: https://www.postgresql.org/docs/9.5/sql-set.html -- Michael --LOFa/7p01oE5IkZH Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmATmacACgkQnvQgOdby QH093Q/+OiQib2r2oECbT+5F/r+rIX/nFd16qogxwUl/9nkcxQ96kLvAGb/r2di7 UyaFXSv5If8So0XeWLK5lzjUVHqb/EejMRrpBdqbjKi/X6Z9+Pwv3qFe3AGjpuk0 LXkD9/veaxcQTHGRx1bpsl/TpLSzQ0Xd4SwsltTVUl0NnSdAgbVp/VaX4sRIwm4Y 3IAK5yQo0V3hmj+hvDnpz6nueC6VJ78bG3du+8KegOKjxrD+NvfspRxTYHBB3IGH H9cH3P/sDh8hgy3xorwSxiPloMx/u1DdXIoZVPWh4escu6Dg50Px8z6OkIXkL436 kscpfPh4WtOXe9eLx07WV/ZgI5CxctI8PdTikA1GMkecbIaQJhe6xWMp2ulQt403 0yc7zpwc+fIvdSmFPj+Na2M6rh46tzT8sR39zRLk0O/iMBw27O8SC7phw5liLiRe 9hCGBfqueGDJhsLvL5K/7g37GOy/m6DekyIDRHEN3lJ3H+acQf0NF63iVN1Eizg9 Jp6uYrNMUhwxkffenAupMMZnkdcXKXxER2x2EmZ+Aw3WEfNbQNwblJmFodVWs4ay pERszwx+zC71iiI1WkpXVDghyfJlmzIojCt6GrFWVWbU8FWymWWmLs5pbmiXWw4u Pv/OMUtE5fzrVR7vJ+mzlV88hz0R1JxCxUtJyL8CBnx/DYHw5Ps= =uV9H -----END PGP SIGNATURE----- --LOFa/7p01oE5IkZH--