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 1oszxV-0008N3-QU for pgsql-general@arkaria.postgresql.org; Thu, 10 Nov 2022 05:18:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oszxU-0005O0-Nz for pgsql-general@arkaria.postgresql.org; Thu, 10 Nov 2022 05:18:36 +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 1oszxU-0005Jy-Bt for pgsql-general@lists.postgresql.org; Thu, 10 Nov 2022 05:18:36 +0000 Received: from wout5-smtp.messagingengine.com ([64.147.123.21]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oszxR-0006vf-U7 for pgsql-general@lists.postgresql.org; Thu, 10 Nov 2022 05:18:35 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id DAEDA32009A1; Thu, 10 Nov 2022 00:18:31 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Thu, 10 Nov 2022 00:18:32 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding: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=1668057511; x= 1668143911; bh=9+ArD/s85gDEM+NI6VW3AJ6eOPdRLyI/xDxZ5KJeSn0=; b=r LPzFDdiT6OVtHN0EgW5bQyXDN5X+H65lewSk2Legcme9kNOBdj3aNqKhdVPFFcj5 1S0t809PPiKodRJrH8dZ+kKTYsYeCUJkUCYeE9OJ8cRf03V89z2goD+Tm3liaeDI V4O03AOrZmIJBQVN9Pmc0e/3jOL+pTAh/LvBaXLlOQ/iLkzAou7lmODakW0fKvTj dbpIn0CLZWfmLJxPouWeYq82kmFPDE7qn+ScoagtiZULwgZjFDtfw0uHMKwo2zEj 1m4sSSU2JPZNS0A+7aiS2IgonR/rKNehO2kSVeByUYyPPpIE3DkiRi4SZrDDrxIA gxy4K2ktzDHwyphMqCRkA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :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=fm1; t=1668057511; x= 1668143911; bh=9+ArD/s85gDEM+NI6VW3AJ6eOPdRLyI/xDxZ5KJeSn0=; b=E 0r123mLJ3Uq+9heOoUAgeUDKkGl3U6Tp8waEAryLN+nOLfggeRJoAYzkHDUMnT8h l1oI9Q40Z+KmSz9/G2w2SltdMVClpk/2DwYa3m6ScZPGba74clp3HW3JR9mtyrD1 B46qbkhEccreElkkBoX1xMMgqqsyoG0oRBfUp7PqeTnJJIQB+Z5rdf1Kf/SxIFnI sIjBYcifzfSaAVPMYi0RSFO/VsrgYNp6+GPkbEu7TzjVbTIoGTOATBB+CwoweCst s+1xAFIxPGWRN5dZHTup9lM+xd0pS45R4VLOdniYEJlWvSa9gxRw3prVvrc8mntu 2HfWP1cfjEdcTXrpPGUWg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvgedrfeefgdekfecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpefkffggfgfuvfevfhfhjggtgfesthgsredttdefjeenucfhrhhomheptegurhhi rghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtoh hmqeenucggtffrrghtthgvrhhnpeeftddvgeeuveejiefgueetgefhhfduvdehvdevleek gfeuveeufeffueffkeetieenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmh grihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhm X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 10 Nov 2022 00:18:30 -0500 (EST) Message-ID: <4ef0194d-a851-de38-e4b1-c6b8cd1e4fe6@aklaver.com> Date: Wed, 9 Nov 2022 21:18:30 -0800 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.1 Subject: Re: "set role" semantics Content-Language: en-US To: Bryn Llewellyn Cc: "David G. Johnston" , pgsql-general list References: <7F67C2B7-B054-408A-A2B4-2A9BF31B1855@yugabyte.com> <343d00c6-afee-3416-ee43-b3f9efa5bc0e@aklaver.com> From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gMTEvOS8yMiAxNToyMywgQnJ5biBMbGV3ZWxseW4gd3JvdGU6DQo+IGFkcmlhbi5rbGF2 ZXJAYWtsYXZlci5jb20gd3JvdGU6DQo+Pg0KPj4+IGJyeW5AeXVnYWJ5dGUuY29tIHdyb3Rl Og0KPj4NCj4+IENvbm5lY3RpbmcgdG8gZGF0YWJhc2UgYW5kIHRoZSByb2xlIHRoYXQgaXMg aW4gcGxheSBpbnNpZGUgYSBzZXNzaW9uIGFyZSB0d28gZGlmZmVyZW50IHRoaW5ncy4gTWFr aW5nIHRoZW0gdGhlIHNhbWUgd291bGQgbWFrZSB0aGluZ3MgW3NlY3VyaXR5IGRlZmluZSB2 cyAic2VjdXJpdHkgaW52b2tlciJdIGdvIHNpZGV3YXlzLg0KPiANCj4gSSBzYWlkIG5vdGhp bmcgdG8gc3VnZ2VzdCB0aGF0IHRoZSByb2xlIHdpdGggd2hpY2ggeW91IGNvbm5lY3QgdG8g YSBkYXRhYmFzZSBzaG91bGQgYmUgaWRlbnRpY2FsLCBhbHdheXMsIHRvIHdoYXQgImN1cnJl bnRfcm9sZSIgcmV0dXJucy4gSSBzcGVjdWxhdGVkIG9ubHkgdGhhdCBhbiBlbmhhbmNlZCBw cml2aWxlZ2Ugc2NoZW1lIHRoYXQgbGltaXRlZCB0aGUgdGFyZ2V0IG9mICJzZXQgcm9sZSIg dG8gdGhvc2UgdGhhdCBoYXZlICJjb25uZWN0IiBvbiB0aGUgY3VycmVudCBkYXRhYmFzZSBt aWdodCBiZSBuaWNlLiBJIGNhbid0IHNlZSB0aGF0IHRoaXMgd291bGQgaW50ZXJmZXJlIHdp dGggdGhlICJzZWN1cml0eSIgbm90aW9uIGZvciBhIHN1YnByb2dyYW0uIEFmdGVyIGFsbCwg aXQncyBhbHJlYWR5IHBvc3NpYmxlIGZvciByb2xlICJyMSIgdG8gaW52b2tlIGEgInNlY3Vy aXR5IGRlZmluZXIiIHN1YnByb2dyYW0gb3duZWQgYnkgcm9sZSAicjIiIHdoZW4gInIxIiBj YW5ub3QgInNldCByb2xlIiB0byAicjIiLiAoVGhpcyBpcyBwcm9iYWJseSB0aGUgb3Zlcndo ZWxtaW5nbHkgY29tbW9uIGNhc2UuKQ0KPiANCj4gSSBiZWxpZXZlIHRoYXQgSSBkbyB1bmRl cnN0YW5kIHRoZSBidXNpbmVzcyBvZiB0aGVzZSB0d28gInNlY3VyaXR5IiBraW5kcyBmb3Ig dXNlci1kZWZpbmVkIGZ1bmN0aW9ucyBhbmQgcHJvY2VkdXJlcyB3ZWxsLiAoQW5kLCB5ZXMs IEkga25vdyB0aGF0IGEgInNldCByb2xlIiBhdHRlbXB0IGluIGEgInNlY3VyaXR5IGRlZmlu ZXIiIGNvbnRleHQgY2F1c2VzIGEgcnVuLXRpbWUgZXJyb3IuKSBCdXQgdGhhbmtzIGZvciBt ZW50aW9uaW5nIHRoZSB0b3BpYy4gVGhlcmUncyBhIGNlcnRhaW4gZmFtaWx5IHJlc2VtYmxh bmNlIGJldHdlZW4gYSAic2VjdXJpdHkgZGVmaW5lciIgc3VicHJvZ3JhbSBhbmQgInNldCBy b2xlIiBpbiB0aGF0IGVhY2ggYnJpbmdzIHRoZSBvdXRjb21lIHRoYXQgdGhlIHZhbHVlIHRo YXQgImN1cnJlbnRfcm9sZSIgcmV0dXJucyBtaWdodCBkaWZmZXIgZnJvbSB0aGUgdmFsdWUg dGhhdCAic2Vzc2lvbl91c2VyIiByZXR1cm5zLiBBbmQgeW91IGNhbiBjZXJ0YWlubHkgYXJy YW5nZSBpdCBzbyB0aGF0IGEgInNlY3VyaXR5IGRlZmluZXIiIHN1YnByb2dyYW0gaXMgb3du ZWQgYnkgYSByb2xlIHRoYXQgZG9lcyBub3QgaGF2ZSAiY29ubmVjdCIgb24gdGhlIGRhdGFi YXNlIHdoZXJlIHRoZSBzdWJwcm9ncmFtIGV4aXN0cy4gVGhlcmUgaXMsIHRob3VnaCwgYSBk aWZmZXJlbmNlIGJldHdlZW4gdGhlIHR3byBwYXJhZGlnbXMgaW4gdGhhdCB0aGUgc3VicHJv Z3JhbSBmb2xsb3dzIGEgc3RhY2tlZCBiZWhhdmlvciBzbyB0aGF0IHdoZW4gdGhlIHN1YnBy b2dyYW0gdGhhdCdzIGZpcnN0IGNhbGxlZCBleGl0cywgdGhlICJjdXJyZW50X3JvbGUiIHZh bHVlIGlzIGJhY2sgd2hlcmUgaXQgd2FzIHdoZW4gdGhlIGNhbGwgd2FzIG1hZGUuIEluIGNv bnRyYXN0ICJzZXQgcm9sZSIgbWFrZXMgYSBkdXJhYmxlIGNoYW5nZSB0aGF0IHlvdSBjYW4g c2VlIGF0IHRoZSAicHNxbCIgcHJvbXB0IChtZW50aW9uaW5nIHRoaXMgYXMgYW4gZXhhbXBs ZSBvZiBhbnkgY2xpZW50KS4gQW5kIHlvdSBjYW4gdXNlICJzZXQgcm9sZSIgdG8gcm9hbSBh cm91bmQsIG9uIGRlbWFuZCwgYW1vbmcgYW55IG51bWJlciBvZiByb2xlcyBpbiB0aGUgc2V0 IHRoYXQgYWxsb3dzIHlvdSBkbyBkbyB0aGlzIGluIGFueSBvcmRlci4gVGhpcyBmZWVscyBk aWZmZXJlbnTigJRhdCBsZWFzdCB0byBtZS4NCj4gDQo+IEFueXdheSwgYWxsIHRoaXMgaXMg bW9vdCAoZXhjZXB0IGluIHRoYXQgdGhpbmtpbmcgYWJvdXQgaXQgaGVscHMgbWUgdG8gZW5y aWNoIG15IG1lbnRhbCBtb2RlbCkgYmVjYXVzZSB0aGUgcHJpdmlsZWdlIG5vdGlvbnMgaGVy ZSB3aWxsIG5ldmVyIGNoYW5nZS4NCg0KU28sIEkgd2FudCBpdCBidXQgbm90IHJlYWxseS4N Cg0KPiANCj4+PiA8YXNpZGU+DQo+Pj4gWW91IG1lbnRpb25lZCBhY2Nlc3MgdG8gdGhlIGNh dGFsb2cgdGFibGVzLiBUaGlzLCB0b28sIGJlbG9uZ3MgdG8gdGhlIGRpc2N1c3Npb24gb2Yg dGhlIHByaW5jaXBsZSBvZiBsZWFzdCBwcml2aWxlZ2UuIFRoaXMgYWNjZXNzIGlzIG5vdCBo YXJkIHdpcmVkLiBSYXRoZXIsIGl0J3MganVzdCBhIG1hbmlmZXN0YXRpb24gb2YgdGhlIGRl ZmF1bHQgcmVnaW1lLiBJJ3ZlIHByb3RvdHlwZWQgYSByZWdpbWUgd2hlcmUgdGhlIHByaXZp bGVnZXMgdGhhdCB5b3UgbmVlZCB0byBhY2Nlc3MgdGhlc2UgdGFibGVzIChhbmQgb3RoZXIg dGhpbmdzIHRvbykgYXJlIHJldm9rZWQgZnJvbSBwdWJsaWMgYW5kIChmb3IgY29udmVuaWVu Y2UpIGFyZSBncmFudGVkIHRvIGEgc2luZ2xlIGRlZGljYXRlZCByb2xlLiBUaGlzIG1lYW5z IHRoYXQgaXQncyBlYXN5IHRvIG1ha2UgaXQgc3VjaCB0aGF0IHRoZSByb2xlKHMpIHRoYXQg Y2xpZW50cyB1c2UgdG8gY29ubmVjdCBjYW4ndCBxdWVyeSB0aGUgY2F0YWxvZ+KAlG9yLCBp ZiB5b3UgcHJlZmVyLCBjYW4gYWNjZXNzIGV4YWN0bHkgYW5kIG9ubHkgdGhvc2UgY2F0YWxv ZyBpdGVtcyB0aGF0IHRoZXkgbmVlZCB0by4gSSdtIHBsZWFzZWQgd2l0aCBob3cgaXQgd29y a2VkIG91dC4gQW5kIEknbGwgcHVyc3VlIHRoaXMgcmVnaW1lIGZ1cnRoZXIuDQo+Pj4gPC9h c2lkZT4NCj4+DQo+PiBIYXZlIHlvdSBhY3R1YWxseSBkb25lIHRoYXQgYW5kIHRyaWVkIHRv IHJ1biBTUUwgc3RhdGVtZW50cz8gVGhleSBhcmUgY2FsbGVkIHN5c3RlbSBjYXRhbG9ncyBi ZWNhdXNlIHRoZXkgYXJlIHVzZWQgYnkgdGhlIHN5c3RlbSB0byBnZXQgdGhlIGluZm9ybWF0 aW9uIG5lY2Vzc2FyeSB0byBkbyB0aGluZ3MuIFRocm93aW5nIHJlc3RyaWN0aW9ucyBvbiB0 aGVpciBhY2Nlc3Mgd291bGQgYmUgYWtpbiB0byBwb3VyaW5nIHNhbmQgaW4gYSBnZWFyYm94 LCBsb3RzIG9mIHN0cmFuZ2UgYmVoYXZpb3IgYW5kIHRoZW4gbm90aGluZy4NCj4gDQo+IFll cyBJIGhhdmUgYWN0dWFsbHkgZG9uZSB0aGlzLiBCdXQgcmlnb3JvdXMgdGVzdGluZyByZW1h aW5zIHRvIGJlIGRvbmUuIEkndmUgaW1wbGVtZW50ZWQgdGhlIHNjaGVtZSBvbmx5IHdpdGhp biBhIGRpc2NpcGxpbmVkIGJpZ2dlciBwaWN0dXJlLiBJJ3ZlIG1lbnRpb25lZCB0aGUgdGhp bmtpbmcgdGhhdCBJJ2xsIHNrZXRjaCBub3csIGJlZm9yZSwgaW4gb3RoZXIgY29udGV4dHMu IEl0J3Mgbm90IG9yaWdpbmFsLiBNYW55IHJlYWwtd29ybGQgYXBwbGljYXRpb25zIGZvbGxv dyBpdC4gSSBsaWtlIHRvIHJlZmVyIHRvIGl0IGFzIHRoZSAiaGFyZCBzaGVsbCIgcGFyYWRp Z20uIEhlcmUsIHRoZSBvd25lcnNoaXAgb2YgdGhlIHZhcmlvdXMgYXJ0aWZhY3RzIHRoYXQg aW1wbGVtZW50IGFuIGFwcGxpY2F0aW9uJ3MgZGF0YWJhc2UgYmFja2VuZCBpcyBzcHJlYWQg YW1vbmcgYXMgbWFueSByb2xlcyBhcyB5b3UgcGxlYXNlLiBGb3IgZXhhbXBsZSwgdGFibGVz IGFuZCB0aGVpciBhc3NvY2lhdGVkIGFydGlmYWN0cyAobGlrZSBpbmRleGVzLCBzZXF1ZW5j ZXMsIGFuZCBzbyBvbikgd291bGQgaGF2ZSBhIGRpZmZlcmVudCBvd25lciBmcm9tIHRoZSB1 c2VyLWRlZmluZWQgc3VicHJvZ3JhbXMgdGhhdCBpbXBsZW1lbnQgdGhlIGJ1c2luZXNzIGZ1 bmN0aW9ucyB0aGF0IGFjY2VzcyB0aGUgdGFibGVzLiBTaWduaWZpY2FudGx5LCBjbGllbnQt c2lkZSBhY2Nlc3MgdG8gdGhpcyB3aG9sZSBzaG9vdGluZyBtYXRjaCB3b3VsZCBiZSB2aWEg b25lIChvciBhIGZldykgZGVkaWNhdGVkICJjbGllbnQiIHJvbGVzLiBTdWNoIGEgcm9sZSBo YXMgb25seSAiY29ubmVjdCIgb24gdGhlIGRhdGFiYXNlIHRoYXQgaG91c2VzIHRoZSBhcHBs aWNhdGlvbidzIGJhY2tlbmQuIEFuZCBpdCBvd25zIG5vIHNjaGVtYSBhbmQgbm8gb2JqZWN0 cyBpbiBvdGhlciBzY2hlbWFzLiBSYXRoZXIsIGl0J3MganVzdCB0aGUgdGFyZ2V0IGZvciB0 aGUgImV4ZWN1dGUiIHByaXZpbGVnZSBvZiB0aG9zZSBmZXcgb2YgYWxsIHRoZSB1c2VyLWRl ZmluZWQgc3VicHJvZ3JhbXMgdGhhdCBqb2ludGx5IGRlZmluZSB0aGUgZGF0YWJhc2UncyBB UEkuIFRoZSBwb2ludCAoY29uZm9ybWluZyB0byB0aGUgcHJpbmNpcGxlIG9mIGxlYXN0IHBy aXZpbGVnZSkgaXMgdGhhdCBzZXNzaW9ucyB0aGF0IGNvbm5lY3QgYXMgImNsaWVudCIgbXVz dCBub3QgYmUgYWxsb3dlZCB0byBkbyBhcmJpdHJhcnkgU1FMLiBSYXRoZXIsIHRoZXkgc2hv dWxkIGJlIGFibGUgdG8gZG8gb25seSB3aGF0IGhhcyBiZWVuIGV4cGxpY2l0bHkgIndoaXRl LWxpc3RlZCIgaW4gYnkgdGhlIGVuY2Fwc3VsYXRpb24gcHJvdmlkZWQgYnkgdGhlIEFQSS1k ZWZpbmluZyBzdWJwcm9ncmFtcy4NCg0KQWxsIHJpZ2h0IHRoYXQgSSBnZXQuDQoNCg0KDQot LSANCkFkcmlhbiBLbGF2ZXINCmFkcmlhbi5rbGF2ZXJAYWtsYXZlci5jb20NCg0K