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 1mM8Gr-0000pv-5a for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Sep 2021 12:26:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mM8Gn-0001yY-Ve for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Sep 2021 12:26:09 +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 1mM8Gn-0001yP-Ns for pgsql-hackers@lists.postgresql.org; Fri, 03 Sep 2021 12:26:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mM8Gk-0000ro-Nu for pgsql-hackers@lists.postgresql.org; Fri, 03 Sep 2021 12:26:09 +0000 Received: from coridan.postgresql.org ([2001:4800:3e1:1::213]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mM8Gg-0004XO-VI for pgsql-hackers@lists.postgresql.org; Fri, 03 Sep 2021 12:26:02 +0000 Received: from localhost ([127.0.0.1] helo=coridan.postgresql.org) by coridan.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mM8Gf-0004pD-Tz for pgsql-hackers@lists.postgresql.org; Fri, 03 Sep 2021 12:26:01 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Subject: Re: psql: \dl+ to list large objects privileges To: pgsql-hackers@lists.postgresql.org From: Georgios Kokolatos Cc: Pavel Luzanov Date: Fri, 03 Sep 2021 12:25:44 +0000 User-Agent: pgcommitfest X-cfsender: gkokolatos In-Reply-To: <90da33e5-5886-11f0-d22f-b2ff8b2d4b99@postgrespro.ru> References: <6d722115-6297-bc53-bb7f-5f150e765299@postgrespro.ru> <90da33e5-5886-11f0-d22f-b2ff8b2d4b99@postgrespro.ru> Message-ID: <163067194414.1167.8140856874411625212.pgcf@coridan.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk VGhlIGZvbGxvd2luZyByZXZpZXcgaGFzIGJlZW4gcG9zdGVkIHRocm91Z2ggdGhlIGNvbW1pdGZl c3QgYXBwbGljYXRpb246Cm1ha2UgaW5zdGFsbGNoZWNrLXdvcmxkOiAgbm90IHRlc3RlZApJbXBs ZW1lbnRzIGZlYXR1cmU6ICAgICAgIG5vdCB0ZXN0ZWQKU3BlYyBjb21wbGlhbnQ6ICAgICAgICAg ICBub3QgdGVzdGVkCkRvY3VtZW50YXRpb246ICAgICAgICAgICAgbm90IHRlc3RlZAoKSGksDQoN CnRoYW5rIHlvdSBmb3IgdGhlIHBhdGNoLCBJIHBlcnNvbmFsbHkgdGhpbmsgaXQgaXMgYSB1c2Vm dWwgYWRkaXRpb24gYW5kIHRodXMgaXQNCmdldHMgbXkgdm90ZS4gSG93ZXZlciwgSSBhbHNvIHRo aW5rIHRoYXQgdGhlIHByb3Bvc2VkIGNvZGUgd2lsbCBuZWVkIHNvbWUNCmNoYW5nZXMuDQoNCk9u IGEgaGlnaCBsZXZlbCBJIHdpbGwgcmVjb21tZW5kIHRoZSBhZGRpdGlvbiBvZiB0ZXN0cy4gVGhl cmUgYXJlIHNpbWlsYXIgdGVzdHMNCnByZXNlbnQgaW46DQogICAgLi9zcmMvdGVzdC9yZWdyZXNz L3NxbC9wc3FsLnNxbA0KDQpJIHdpbGwgYWxzbyBpbnF1aXJlIGFzIHRvIHRoZSBuZWVkIGZvciBy ZW5hbWluZyB0aGUgZnVuY3Rpb24gYGRvX2xvX2xpc3RgIHRvDQpgbGlzdExhcmdlT2JqZWN0c2Ag YW5kIGl0cyBtb3ZlIHRvIGRlc2NyaWJlLmMuIGZyb20gbGFyZ2Vfb2JqLmMuIEluIGl0c2VsZiBp dCBpcw0Kbm90IG5lY2Vzc2FyaWx5IGEgYmxvY2tpbmcgcG9pbnQsIHRob3VnaCBpdCB3aWxsIHJl cXVpcmUgc29tZSBzdHJvbmcgYXJndW1lbnRzDQpmb3IgZG9pbmcgc28uDQoNCkFwcGx5aW5nIHRo ZSBwYXRjaCwgZ2VuZXJhdGVzIHNldmVyYWwgd2hpdGVzcGFjZSB3YXJuaW5ncy4gSXQgd2lsbCBi ZSBoZWxwZnVsDQppZiB0aG9zZSB3YXJuaW5ncyBhcmUgcmVtb3ZlZC4NCg0KVGhlIHBhdGNoIGNv bnRhaW5zOg0KDQogICAgICAgICAgICAgICAgICAgICAgICBjYXNlICdsJzoNCi0gICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgc3VjY2VzcyA9IGRvX2xvX2xpc3QoKTsNCisgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgc3VjY2VzcyA9IGxpc3RMYXJnZU9iamVjdHMoc2hvd192ZXJi b3NlKTsNCg0KDQpJdCBtaWdodCBiZSBvZiBzb21lIGludGVyZXN0IHRvIGNvbnNpZGVyIGluIHRo ZSBhYm92ZSB0byBjaGVjayB0aGUgdmFsdWUgb2YgdGhlDQpuZXh0IGNoYXJhY3RlciBpbiBjb21t YW5kIG9yIGVtaXQgYW4gZXJyb3IgaWYgbm90IHZhbGlkLiBTdWNoIGEgcGF0dGVybiBjYW4gYmUN CmZvdW5kIGluIHRoZSBzYW1lIHN3aXRjaCBibG9jayBhcyBmb3IgZXhhbXBsZToNCg0KICAgICAg ICAgICAgICAgICAgICBzd2l0Y2ggKGNtZFsyXSkNCiAgICAgICAgICAgICAgICAgICAgew0KICAg ICAgICAgICAgICAgICAgICAgICAgY2FzZSAnXDAnOg0KICAgICAgICAgICAgICAgICAgICAgICAg Y2FzZSAnKyc6DQogICAgICAgICAgICAgICAgPHNuaXA+DQogICAgICAgICAgICAgICAgICAgICAg ICBzdWNjZXNzID0gLi4uDQogICAgICAgICAgICAgICAgPC9zbmlwPg0KICAgICAgICAgICAgICAg ICAgICAgICAgICAgIGJyZWFrOw0KICAgICAgICAgICAgICAgICAgICAgICAgZGVmYXVsdDoNCiAg ICAgICAgICAgICAgICAgICAgICAgICAgICBzdGF0dXMgPSBQU1FMX0NNRF9VTktOT1dOOw0KICAg ICAgICAgICAgICAgICAgICAgICAgICAgIGJyZWFrOw0KICAgICAgICAgICAgICAgICAgICB9DQoN Cg0KVGhlIHBhdGNoIGNvbnRhaW5zOg0KDQogICAgICAgICAgICAgICAgZWxzZSBpZiAoc3RyY21w KGNtZCArIDMsICJsaXN0IikgPT0gMCkNCi0gICAgICAgICAgICAgICAgICAgICAgIHN1Y2Nlc3Mg PSBkb19sb19saXN0KCk7DQorICAgICAgICAgICAgICAgICAgICAgICBzdWNjZXNzID0gbGlzdExh cmdlT2JqZWN0cyhmYWxzZSk7DQorDQorICAgICAgICAgICAgICAgZWxzZSBpZiAoc3RyY21wKGNt ZCArIDMsICJsaXN0KyIpID09IDApDQorICAgICAgICAgICAgICAgICAgICAgICBzdWNjZXNzID0g bGlzdExhcmdlT2JqZWN0cyh0cnVlKTsNCg0KDQpJbiBhIGZhc2hpb24gc2ltaWxhciB0byBgZXhl Y19jb21tYW5kX2xpc3RgLCBpdCBtaWdodCBiZSBpbnRlcmVzdGluZyB0byBjb25zaWRlcg0KZXhw cmVzc2luZyB0aGUgYWJvdmUgYXM6DQoNCiAgICAgICAgc2hvd192ZXJib3NlID0gc3RyY2hyKGNt ZCwgJysnKSA/IHRydWUgOiBmYWxzZTsNCiAgICAgICAgPHNuaXA+DQogICAgICAgIGVsc2UgaWYg KHN0cmNtcChjbWQgKyAzLCAibGlzdCIpID09IDANCiAgICAgICAgICAgICAgICBzdWNjZXNzID0g ZG9fbG9fbGlzdChzaG93X3ZlcmJvc2UpOw0KDQoNClRob3VnaHRzPw0KDQpDaGVlcnMsDQovL0dl b3JnaW9z