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 1qrjiP-005eAn-7J for pgsql-committers@arkaria.postgresql.org; Sat, 14 Oct 2023 18:50:21 +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 1qrjiM-008605-CP for pgsql-committers@arkaria.postgresql.org; Sat, 14 Oct 2023 18:50:19 +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 1qrjiM-0085zx-08 for pgsql-committers@lists.postgresql.org; Sat, 14 Oct 2023 18:50:18 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qrjiF-000Tz0-KG for pgsql-committers@lists.postgresql.org; Sat, 14 Oct 2023 18:50:17 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qrjiE-00033A-Sb for pgsql-committers@lists.postgresql.org; Sat, 14 Oct 2023 18:50:10 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qrjiD-000YbO-Tl for pgsql-committers@lists.postgresql.org; Sat, 14 Oct 2023 18:50:10 +0000 Content-Type: multipart/mixed; boundary="===============9123676888531652275==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Harden has_xxx_privilege() functions against concurrent object d X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sat, 14 Oct 2023 18:50:10 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============9123676888531652275== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SGFyZGVuIGhhc194eHhfcHJpdmlsZWdlKCkgZnVuY3Rpb25zIGFnYWluc3QgY29uY3VycmVudCBv YmplY3QgZHJvcHMuCgpUaGUgdmVyc2lvbnMgb2YgdGhlc2UgZnVuY3Rpb25zIHRoYXQgYWNjZXB0 IG9iamVjdCBPSURzIGFyZSBzdXBwb3NlZAp0byByZXR1cm4gTlVMTCwgcmF0aGVyIHRoYW4gZmFp bGluZywgaWYgdGhlIHRhcmdldCBvYmplY3QgaGFzIGJlZW4KZHJvcHBlZC4gIFRoaXMgbWFrZXMg aXQgc2FmZShyKSB0byB1c2UgdGhlbSBpbiBxdWVyaWVzIHRoYXQgc2NhbgpjYXRhbG9ncywgc2lu Y2UgdGhlIGZ1bmN0aW9ucyB3aWxsIGJlIGFwcGxpZWQgdG8gb2JqZWN0cyB0aGF0IGFyZQp2aXNp YmxlIGluIHRoZSBxdWVyeSdzIHNuYXBzaG90IGJ1dCBtaWdodCBub3cgYmUgZ29uZSBhY2NvcmRp bmcgdG8KdGhlIGNhdGFsb2cgc25hcHNob3QuICBJbiBtb3N0IGNhc2VzIHdlIGltcGxlbWVudGVk IHRoaXMgYnkgZG9pbmcKYSBTZWFyY2hTeXNDYWNoZUV4aXN0cyB0ZXN0IGFuZCBhc3N1bWluZyB0 aGF0IGlmIHRoYXQgc3VjY2VlZHMsIHdlCmNhbiBzYWZlbHkgaW52b2tlIHRoZSBhcHByb3ByaWF0 ZSBhY2xjaGsuYyBmdW5jdGlvbiwgd2hpY2ggd2lsbAppbW1lZGlhdGVseSByZS1mZXRjaCB0aGUg c2FtZSBzeXNjYWNoZSBlbnRyeS4gIEl0IHdhcyBhcmd1ZWQgdGhhdAppZiB0aGUgZXhpc3RlbmNl IHRlc3Qgc3VjY2VlZHMgdGhlbiB0aGUgZm9sbG93dXAgZmV0Y2ggbXVzdCBzdWNjZWVkCmFzIHdl bGwsIGZvciBsYWNrIG9mIGFueSBpbnRlcnZlbmluZyBBY2NlcHRJbnZhbGlkYXRpb25NZXNzYWdl cyBjYWxsLgoKQWxleGFuZGVyIExha2hpbiBkZW1vbnN0cmF0ZWQgdGhhdCB0aGlzIGlzIG5vdCBz byB3aGVuCkNBVENBQ0hFX0ZPUkNFX1JFTEVBU0UgaXMgZW5hYmxlZDogdGhlIHN5c2NhY2hlIGVu dHJ5IHdpbGwgYmUgZm9yY2libHkKZHJvcHBlZCBhdCB0aGUgZW5kIG9mIFNlYXJjaFN5c0NhY2hl RXhpc3RzLCBhbmQgdGhlbiBpdCBpcyBwb3NzaWJsZQpmb3IgdGhlIGNhdGFsb2cgc25hcHNob3Qg dG8gZ2V0IGFkdmFuY2VkIHdoaWxlIHJlLWZldGNoaW5nIHRoZSBlbnRyeS4KQWxleGFuZGVyJ3Mg dGVzdCBjYXNlIHJlcXVpcmVzIHRoZSBvcGVyYXRpb24gdG8gaGFwcGVuIGluc2lkZSBhCnBhcmFs bGVsIHdvcmtlciwgYnV0IHRoYXQgc2VlbXMgaW5jaWRlbnRhbCB0byB0aGUgZnVuZGFtZW50YWwg cHJvYmxlbS4KV2hhdCByZW1haW5zIG9ic2N1cmUgaXMgd2hldGhlciB0aGVyZSBpcyBhIHdheSBm b3IgdGhpcyB0byBoYXBwZW4gaW4gYQpub24tZGVidWcgYnVpbGQuICBOb25ldGhlbGVzcywgQ0FU Q0FDSEVfRk9SQ0VfUkVMRUFTRSBpcyBhIHZlcnkgdXNlZnVsCnRlc3QgbWV0aG9kb2xvZ3ksIHNv IHdlJ2QgYmV0dGVyIG1ha2UgdGhlIGNvZGUgc2FmZSBmb3IgaXQuCgpBZnRlciBzb21lIGRpc2N1 c3Npb24gd2UgY29uY2x1ZGVkIHRoYXQgdGhlIG1vc3QgZnV0dXJlLXByb29mIGZpeAppcyB0byBn aXZlIHVwIHRoZSBhc3N1bXB0aW9uIHRoYXQgY2hlY2tpbmcgU2VhcmNoU3lzQ2FjaGVFeGlzdHMg Y2FuCmd1YXJhbnRlZSBzdWNjZXNzIG9mIGEgbGF0ZXIgZmV0Y2guICBBdCBiZXN0IHRoYXQgYXNz dW1wdGlvbiBsZWFkcwp0byBmcmFnaWxlIGNvZGUgLS0tIGZvciBleGFtcGxlLCBoYXNfdHlwZV9w cml2aWxlZ2UgYXBwZWFycyBicm9rZW4KZm9yIGFycmF5IHR5cGVzIGV2ZW4gaWYgeW91IGJlbGll dmUgdGhlIGFzc3VtcHRpb24gaG9sZHMuICBBbmQgaXQncwpub3QgZXZlbiBwYXJ0aWN1bGFybHkg ZWZmaWNpZW50LgoKVGhlcmUgaGFkIGFscmVhZHkgYmVlbiBzb21lIHdvcmsgdG93YXJkcyBleHRl bmRpbmcgdGhlIGFjbGNoay5jCkFQSXMgdG8gaW5jbHVkZSAiaXNfbWlzc2luZyIgb3V0cHV0IGZs YWdzLCBzbyB0aGlzIHBhdGNoIGV4dGVuZHMKdGhhdCB3b3JrIHRvIGNvdmVyIGFsbCB0aGUgYWNs Y2hrLmMgZnVuY3Rpb25zIHRoYXQgYXJlIHVzZWQgYnkgdGhlCmhhc194eHhfcHJpdmlsZWdlKCkg ZnVuY3Rpb25zLiAgKFRoaXMgYWxsb3dzIGdldHRpbmcgcmlkIG9mIHNvbWUKYWQtaG9jIGRlY2lz aW9ucyBhYm91dCBub3QgdGhyb3dpbmcgZXJyb3JzIGluIGNlcnRhaW4gcGxhY2VzIGluCmFjbGNo ay5jLikKCkluIHBhc3NpbmcsIHRoaXMgZml4ZXMgdGhlIGhhc19zZXF1ZW5jZV9wcml2aWxlZ2Uo KSBmdW5jdGlvbnMgdG8KcHJvdmlkZSB0aGUgc2FtZSBndWFyYW50ZWVzIGFzIHRoZWlyIGNvdXNp bnM6IGZvciBzb21lIHJlYXNvbiB0aGUKU2VhcmNoU3lzQ2FjaGVFeGlzdHMgdGVzdHMgbmV2ZXIg Z290IGFkZGVkIHRvIHRob3NlLgoKVGhlcmUgaXMgbW9yZSB3b3JrIHRvIGRvIHRvIHJlbW92ZSB0 aGUgdW5zYWZlIGNvZGluZyBwYXR0ZXJuIHdpdGgKU2VhcmNoU3lzQ2FjaGVFeGlzdHMgaW4gb3Ro ZXIgcGxhY2VzLCBidXQgdGhpcyBpcyBhIHByZXR0eQpzZWxmLWNvbnRhaW5lZCBwYXRjaCBzbyBJ J2xsIGNvbW1pdCBpdCBzZXBhcmF0ZWx5LgoKUGVyIGJ1ZyAjMTgwMTQgZnJvbSBBbGV4YW5kZXIg TGFraGluLiAgR2l2ZW4gdGhlIGxhY2sgb2YgaGFyZCBldmlkZW5jZQp0aGF0IHRoZXJlJ3MgYSBi dWcgaW4gbm9uLWRlYnVnIGJ1aWxkcywgSSdtIGNvbnRlbnQgdG8gZml4IHRoaXMgb25seQppbiBI RUFELiAgKFBlcmhhcHMgd2Ugc2hvdWxkIGNsZWFuIHVwIHRoZSBoYXNfc2VxdWVuY2VfcHJpdmls ZWdlKCkKb3ZlcnNpZ2h0IGluIHRoZSBiYWNrIGJyYW5jaGVzLCBidXQgaW4gdGhlIGFic2VuY2Ug b2YgZmllbGQgY29tcGxhaW50cwpJJ20gbm90IHRvbyBleGNpdGVkIGFib3V0IHRoYXQgZWl0aGVy LikKCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vMTgwMTQtMjhjODFjYjc5ZDQ0Mjk1 ZEBwb3N0Z3Jlc3FsLm9yZwoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpo dHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzQwM2FjMjI2ZGRkNjA3MTI0 NWI3YjI4Mzg2MWMyNjk2MGVhNzI5M2YKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNy Yy9iYWNrZW5kL2NhdGFsb2cvYWNsY2hrLmMgfCAyNDggKysrKysrKysrKysrKysrKysrKysrKysr KysrLS0tLS0tLS0Kc3JjL2JhY2tlbmQvdXRpbHMvYWR0L2FjbC5jICB8IDMwMyArKysrKysrKysr KysrKysrKysrKysrKysrKysrLS0tLS0tLS0tLS0tLS0tCnNyYy9pbmNsdWRlL3V0aWxzL2FjbC5o ICAgICAgfCAgMTEgKy0KMyBmaWxlcyBjaGFuZ2VkLCA0MDIgaW5zZXJ0aW9ucygrKSwgMTYwIGRl bGV0aW9ucygtKQoK --===============9123676888531652275==--