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 1p2Zjq-00059d-2s for pgsql-committers@arkaria.postgresql.org; Tue, 06 Dec 2022 15:20:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p2Zjo-0001K3-UW for pgsql-committers@arkaria.postgresql.org; Tue, 06 Dec 2022 15:20:04 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p2Zjo-0001Ab-Hm for pgsql-committers@lists.postgresql.org; Tue, 06 Dec 2022 15:20:04 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p2Zjm-0006wD-1o for pgsql-committers@lists.postgresql.org; Tue, 06 Dec 2022 15:20:03 +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 1p2Zjl-0000Ni-HQ for pgsql-committers@lists.postgresql.org; Tue, 06 Dec 2022 15:20:01 +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 1p2Zjj-002FW0-QP for pgsql-committers@lists.postgresql.org; Tue, 06 Dec 2022 15:20:00 +0000 Content-Type: multipart/mixed; boundary="===============4479830545219132026==" MIME-Version: 1.0 From: Alvaro Herrera To: pgsql-committers@lists.postgresql.org Subject: pgsql: Rework query relation permission checking X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 06 Dec 2022 15:20:00 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4479830545219132026== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UmV3b3JrIHF1ZXJ5IHJlbGF0aW9uIHBlcm1pc3Npb24gY2hlY2tpbmcKCkN1cnJlbnRseSwgaW5m b3JtYXRpb24gYWJvdXQgdGhlIHBlcm1pc3Npb25zIHRvIGJlIGNoZWNrZWQgb24gcmVsYXRpb25z Cm1lbnRpb25lZCBpbiBhIHF1ZXJ5IGlzIHN0b3JlZCBpbiB0aGVpciByYW5nZSB0YWJsZSBlbnRy aWVzLiAgU28gdGhlCmV4ZWN1dG9yIG11c3Qgc2NhbiB0aGUgZW50aXJlIHJhbmdlIHRhYmxlIGxv b2tpbmcgZm9yIHJlbGF0aW9ucyB0aGF0Cm5lZWQgdG8gaGF2ZSBwZXJtaXNzaW9ucyBjaGVja2Vk LiAgVGhpcyBjYW4gbWFrZSB0aGUgcGVybWlzc2lvbiBjaGVja2luZwpwYXJ0IG9mIHRoZSBleGVj dXRvciBpbml0aWFsaXphdGlvbiBuZWVkbGVzc2x5IGV4cGVuc2l2ZSB3aGVuIG1hbnkKaW5oZXJp dGFuY2UgY2hpbGRyZW4gYXJlIHByZXNlbnQgaW4gdGhlIHJhbmdlIHJhbmdlLiAgV2hpbGUgdGhl CnBlcm1pc3Npb25zIG5lZWQgbm90IGJlIGNoZWNrZWQgb24gdGhlIGluZGl2aWR1YWwgY2hpbGQg cmVsYXRpb25zLCB0aGUKZXhlY3V0b3Igc3RpbGwgbXVzdCB2aXNpdCBldmVyeSByYW5nZSB0YWJs ZSBlbnRyeSB0byBmaWx0ZXIgdGhlbSBvdXQuCgpUaGlzIGNvbW1pdCBtb3ZlcyB0aGUgcGVybWlz c2lvbiBjaGVja2luZyBpbmZvcm1hdGlvbiBvdXQgb2YgdGhlIHJhbmdlCnRhYmxlIGVudHJpZXMg aW50byBhIG5ldyBwbGFuIG5vZGUgY2FsbGVkIFJURVBlcm1pc3Npb25JbmZvLiAgRXZlcnkKdG9w LWxldmVsIChpbmhlcml0YW5jZSAicm9vdCIpIFJURV9SRUxBVElPTiBlbnRyeSBpbiB0aGUgcmFu Z2UgdGFibGUKZ2V0cyBvbmUgYW5kIGEgbGlzdCBvZiB0aG9zZSBpcyBtYWludGFpbmVkIGFsb25n c2lkZSB0aGUgcmFuZ2UgdGFibGUuClRoaXMgbmV3IGxpc3QgaXMgaW5pdGlhbGl6ZWQgYnkgdGhl IHBhcnNlciB3aGVuIGluaXRpYWxpemluZyB0aGUgcmFuZ2UKdGFibGUuICBUaGUgcmV3cml0ZXIg Y2FuIGFkZCBtb3JlIGVudHJpZXMgdG8gaXQgYXMgcnVsZXMvdmlld3MgYXJlCmV4cGFuZGVkLiAg RmluYWxseSwgdGhlIHBsYW5uZXIgY29tYmluZXMgdGhlIGxpc3RzIG9mIHRoZSBpbmRpdmlkdWFs CnN1YnF1ZXJpZXMgaW50byBvbmUgZmxhdCBsaXN0IHRoYXQgaXMgcGFzc2VkIHRvIHRoZSBleGVj dXRvciBmb3IKY2hlY2tpbmcuCgpUbyBtYWtlIGl0IHF1aWNrIHRvIGZpbmQgdGhlIFJURVBlcm1p c3Npb25JbmZvIGVudHJ5IGJlbG9uZ2luZyB0byBhCmdpdmVuIHJlbGF0aW9uLCBSYW5nZVRibEVu dHJ5IGdldHMgYSBuZXcgSW5kZXggZmllbGQgJ3Blcm1pbmZvaW5kZXgnCnRoYXQgc3RvcmVzIHRo ZSBjb3JyZXNwb25kaW5nIFJURVBlcm1pc3Npb25JbmZvJ3MgaW5kZXggaW4gdGhlIHF1ZXJ5J3MK bGlzdCBvZiB0aGUgbGF0dGVyLgoKRXhlY3V0b3JDaGVja1Blcm1zX2hvb2sgaGFzIGdhaW5lZCBh bm90aGVyIExpc3QgKiBhcmd1bWVudDsgdGhlCnNpZ25hdHVyZSBpcyBub3c6CnR5cGVkZWYgYm9v bCAoKkV4ZWN1dG9yQ2hlY2tQZXJtc19ob29rX3R5cGUpIChMaXN0ICpyYW5nZVRhYmxlLAogICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgTGlzdCAqcnRlUGVybUlu Zm9zLAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgYm9vbCBl cmVwb3J0X29uX3Zpb2xhdGlvbik7ClRoZSBmaXJzdCBhcmd1bWVudCBpcyBubyBsb25nZXIgdXNl ZCBieSBhbnkgaW4tY29yZSB1c2VzIG9mIHRoZSBob29rLApidXQgd2UgbGVhdmUgaXQgaW4gcGxh Y2UgYmVjYXVzZSB0aGVyZSBtYXkgYmUgb3RoZXIgaW1wbGVtZW50YXRpb25zIHRoYXQKZG8uICBJ bXBsZW1lbnRhdGlvbnMgc2hvdWxkIGxpa2VseSBzY2FuIHRoZSBydGVQZXJtSW5mb3MgbGlzdCB0 bwpkZXRlcm1pbmUgd2hpY2ggb3BlcmF0aW9ucyB0byBhbGxvdyBvciBkZW55LgoKQXV0aG9yOiBB bWl0IExhbmdvdGUgPGFtaXRsYW5nb3RlMDlAZ21haWwuY29tPgpEaXNjdXNzaW9uOiBodHRwczov L3Bvc3Rnci5lcy9tL0NBK0hpd3FHakpEbVVoRFNmdi1VMnFoS0pqdDlTVDdYaDlKWENfaXJzQVEx VEFVc0pZZ0BtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0t LS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2E2MWIxZjc0ODIz YzljNGY3OWM5NTIyNmE0NjFmMWU3YTM2Nzc2NGIKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0t LS0tCmNvbnRyaWIvcG9zdGdyZXNfZmR3L3Bvc3RncmVzX2Zkdy5jICAgICAgICAgICAgICB8ICAx NyArLQpjb250cmliL3NlcGdzcWwvZG1sLmMgICAgICAgICAgICAgICAgICAgICAgICAgICAgfCAg NDIgKysrLS0KY29udHJpYi9zZXBnc3FsL2hvb2tzLmMgICAgICAgICAgICAgICAgICAgICAgICAg IHwgICA2ICstCmNvbnRyaWIvc2VwZ3NxbC9zZXBnc3FsLmggICAgICAgICAgICAgICAgICAgICAg ICB8ICAgMyArLQpzcmMvYmFja2VuZC9jb21tYW5kcy9jb3B5LmMgICAgICAgICAgICAgICAgICAg ICAgfCAgMjMgKy0tCnNyYy9iYWNrZW5kL2NvbW1hbmRzL2NvcHlmcm9tLmMgICAgICAgICAgICAg ICAgICB8ICAxMSArLQpzcmMvYmFja2VuZC9jb21tYW5kcy92aWV3LmMgICAgICAgICAgICAgICAg ICAgICAgfCAgMzMgKysrLQpzcmMvYmFja2VuZC9leGVjdXRvci9leGVjTWFpbi5jICAgICAgICAg ICAgICAgICAgfCAxMTcgKysrKysrLS0tLS0tLQpzcmMvYmFja2VuZC9leGVjdXRvci9leGVjUGFy YWxsZWwuYyAgICAgICAgICAgICAgfCAgIDEgKwpzcmMvYmFja2VuZC9leGVjdXRvci9leGVjVXRp bHMuYyAgICAgICAgICAgICAgICAgfCAxMzQgKysrKysrKysrKy0tLS0tCnNyYy9iYWNrZW5kL25v ZGVzL291dGZ1bmNzLmMgICAgICAgICAgICAgICAgICAgICB8ICAgNiArLQpzcmMvYmFja2VuZC9u b2Rlcy9yZWFkZnVuY3MuYyAgICAgICAgICAgICAgICAgICAgfCAgIDYgKy0Kc3JjL2JhY2tlbmQv b3B0aW1pemVyL3BsYW4vcGxhbm5lci5jICAgICAgICAgICAgIHwgICA2ICsKc3JjL2JhY2tlbmQv b3B0aW1pemVyL3BsYW4vc2V0cmVmcy5jICAgICAgICAgICAgIHwgIDczICsrKysrKy0tCnNyYy9i YWNrZW5kL29wdGltaXplci9wbGFuL3N1YnNlbGVjdC5jICAgICAgICAgICB8ICAgOCArLQpzcmMv YmFja2VuZC9vcHRpbWl6ZXIvcHJlcC9wcmVwam9pbnRyZWUuYyAgICAgICAgfCAgMjEgKy0tCnNy Yy9iYWNrZW5kL29wdGltaXplci91dGlsL2luaGVyaXQuYyAgICAgICAgICAgICB8IDE3MyArKysr KysrKysrKysrKy0tLS0tCnNyYy9iYWNrZW5kL29wdGltaXplci91dGlsL3JlbG5vZGUuYyAgICAg ICAgICAgICB8ICAyMSArKy0Kc3JjL2JhY2tlbmQvcGFyc2VyL2FuYWx5emUuYyAgICAgICAgICAg ICAgICAgICAgIHwgIDY4ICsrKysrLS0tCnNyYy9iYWNrZW5kL3BhcnNlci9wYXJzZV9jbGF1c2Uu YyAgICAgICAgICAgICAgICB8ICAgOSArLQpzcmMvYmFja2VuZC9wYXJzZXIvcGFyc2VfbWVyZ2Uu YyAgICAgICAgICAgICAgICAgfCAgIDkgKy0Kc3JjL2JhY2tlbmQvcGFyc2VyL3BhcnNlX3JlbGF0 aW9uLmMgICAgICAgICAgICAgIHwgMTc4ICsrKysrKysrKysrLS0tLS0tLS0tCnNyYy9iYWNrZW5k L3BhcnNlci9wYXJzZV90YXJnZXQuYyAgICAgICAgICAgICAgICB8ICAxOCArLQpzcmMvYmFja2Vu ZC9wYXJzZXIvcGFyc2VfdXRpbGNtZC5jICAgICAgICAgICAgICAgfCAgIDYgKy0Kc3JjL2JhY2tl bmQvcmVwbGljYXRpb24vbG9naWNhbC93b3JrZXIuYyAgICAgICAgIHwgIDExICstCnNyYy9iYWNr ZW5kL3Jld3JpdGUvcmV3cml0ZURlZmluZS5jICAgICAgICAgICAgICB8ICAyNyArLS0Kc3JjL2Jh Y2tlbmQvcmV3cml0ZS9yZXdyaXRlSGFuZGxlci5jICAgICAgICAgICAgIHwgMjA1ICsrKysrKysr KysrKy0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL3Jld3JpdGUvcmV3cml0ZU1hbmlwLmMgICAgICAg ICAgICAgICB8ICAzMyArKysrCnNyYy9iYWNrZW5kL3Jld3JpdGUvcm93c2VjdXJpdHkuYyAgICAg ICAgICAgICAgICB8ICAyNSArKy0Kc3JjL2JhY2tlbmQvdXRpbHMvYWR0L3JpX3RyaWdnZXJzLmMg ICAgICAgICAgICAgIHwgIDE5ICsrLQpzcmMvYmFja2VuZC91dGlscy9jYWNoZS9yZWxjYWNoZS5j ICAgICAgICAgICAgICAgfCAgIDQgKy0Kc3JjL2luY2x1ZGUvY2F0YWxvZy9jYXR2ZXJzaW9uLmgg ICAgICAgICAgICAgICAgIHwgICAyICstCnNyYy9pbmNsdWRlL2NvbW1hbmRzL2NvcHlmcm9tX2lu dGVybmFsLmggICAgICAgICB8ICAgMyArLQpzcmMvaW5jbHVkZS9leGVjdXRvci9leGVjdXRvci5o ICAgICAgICAgICAgICAgICAgfCAgMTAgKy0Kc3JjL2luY2x1ZGUvbm9kZXMvZXhlY25vZGVzLmgg ICAgICAgICAgICAgICAgICAgIHwgICAzICstCnNyYy9pbmNsdWRlL25vZGVzL3BhcnNlbm9kZXMu aCAgICAgICAgICAgICAgICAgICB8ICA5NCArKysrKysrLS0tLQpzcmMvaW5jbHVkZS9ub2Rlcy9w YXRobm9kZXMuaCAgICAgICAgICAgICAgICAgICAgfCAgIDMgKwpzcmMvaW5jbHVkZS9ub2Rlcy9w bGFubm9kZXMuaCAgICAgICAgICAgICAgICAgICAgfCAgIDMgKwpzcmMvaW5jbHVkZS9vcHRpbWl6 ZXIvaW5oZXJpdC5oICAgICAgICAgICAgICAgICAgfCAgIDIgKwpzcmMvaW5jbHVkZS9wYXJzZXIv cGFyc2Vfbm9kZS5oICAgICAgICAgICAgICAgICAgfCAgIDkgKy0Kc3JjL2luY2x1ZGUvcGFyc2Vy L3BhcnNlX3JlbGF0aW9uLmggICAgICAgICAgICAgIHwgICA0ICsKc3JjL2luY2x1ZGUvcmV3cml0 ZS9yZXdyaXRlSGFuZGxlci5oICAgICAgICAgICAgIHwgICAxICsKc3JjL2luY2x1ZGUvcmV3cml0 ZS9yZXdyaXRlTWFuaXAuaCAgICAgICAgICAgICAgIHwgICAyICsKc3JjL3Rlc3QvbW9kdWxlcy90 ZXN0X29hdF9ob29rcy90ZXN0X29hdF9ob29rcy5jIHwgICA2ICstCnNyYy90ZXN0L3JlZ3Jlc3Mv ZXhwZWN0ZWQvcnVsZXMub3V0ICAgICAgICAgICAgICB8ICAxNCArKwpzcmMvdGVzdC9yZWdyZXNz L3NxbC9ydWxlcy5zcWwgICAgICAgICAgICAgICAgICAgfCAgMTUgKysKc3JjL3Rvb2xzL3BnaW5k ZW50L3R5cGVkZWZzLmxpc3QgICAgICAgICAgICAgICAgIHwgICAyICsKNDcgZmlsZXMgY2hhbmdl ZCwgOTUzIGluc2VydGlvbnMoKyksIDUzMyBkZWxldGlvbnMoLSkKCg== --===============4479830545219132026==--