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 1mL93o-0006uw-QG for pgsql-committers@arkaria.postgresql.org; Tue, 31 Aug 2021 19:04:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mL93n-0003zI-QV for pgsql-committers@arkaria.postgresql.org; Tue, 31 Aug 2021 19:04:39 +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 1mL93k-0002Ex-0F for pgsql-committers@lists.postgresql.org; Tue, 31 Aug 2021 19:04:36 +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 1mL93d-0005t1-Mc for pgsql-committers@lists.postgresql.org; Tue, 31 Aug 2021 19:04:34 +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 1mL93d-0008Vd-3C for pgsql-committers@lists.postgresql.org; Tue, 31 Aug 2021 19:04:29 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mL93c-0004j7-Gt for pgsql-committers@lists.postgresql.org; Tue, 31 Aug 2021 19:04:28 +0000 Content-Type: multipart/mixed; boundary="===============3676792035190847458==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: In pg_dump, avoid doing per-table queries for RLS policies. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 31 Aug 2021 19:04:28 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3676792035190847458== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW4gcGdfZHVtcCwgYXZvaWQgZG9pbmcgcGVyLXRhYmxlIHF1ZXJpZXMgZm9yIFJMUyBwb2xpY2ll cy4KCkZvciBubyBwYXJ0aWN1bGFybHkgZ29vZCByZWFzb24sIGdldFBvbGljaWVzKCkgcXVlcmll ZCBwZ19wb2xpY3kKc2VwYXJhdGVseSBmb3IgZWFjaCB0YWJsZS4gIFdlIGNhbiBjb2xsZWN0IGFs bCB0aGUgcG9saWNpZXMgaW4KYSBzaW5nbGUgcXVlcnkgaW5zdGVhZCwgYW5kIGF0dGFjaCB0aGVt IHRvIHRoZSBjb3JyZWN0IFRhYmxlSW5mbwpvYmplY3RzIHVzaW5nIGZpbmRUYWJsZUJ5T2lkKCkg bG9va3Vwcy4gIE9uIHRoZSByZWdyZXNzaW9uCmRhdGFiYXNlLCB0aGlzIHJlZHVjZXMgdGhlIG51 bWJlciBvZiBxdWVyaWVzIHN1YnN0YW50aWFsbHksIGFuZApwcm92aWRlcyBhIHZpc2libGUgc2F2 aW5ncyBldmVuIHdoZW4gcnVubmluZyBhZ2FpbnN0IGEgbG9jYWwKc2VydmVyLgoKUGVyIGNvbXBs YWludCBmcm9tIEh1YmVydCBEZXBlc3ogTHViYWN6ZXdza2kuICBTaW5jZSB0aGlzIGlzIHN1Y2gK YSBzaW1wbGUgZml4IGFuZCBjYW4gaGF2ZSBhIHZpc2libGUgcGVyZm9ybWFuY2UgYmVuZWZpdCwg YmFjay1wYXRjaAp0byBhbGwgc3VwcG9ydGVkIGJyYW5jaGVzLgoKRGlzY3Vzc2lvbjogaHR0cHM6 Ly9wb3N0Z3IuZXMvbS8yMDIxMDgyNjA4NDQzMC5HQTI2MjgyQGRlcGVzei5jb20KCkJyYW5jaAot LS0tLS0KUkVMXzExX1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVz cWwub3JnL3BnL2NvbW1pdGRpZmYvYTYwODYwZmYzM2ZiZDQxNjg1OTQzZTFjNTlhMTk5ZmU5NWVl OTZiZAoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2Jpbi9wZ19kdW1wL3BnX2R1 bXAuYyB8IDk1ICsrKysrKysrKysrKysrKysrKysrKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t CjEgZmlsZSBjaGFuZ2VkLCA0MyBpbnNlcnRpb25zKCspLCA1MiBkZWxldGlvbnMoLSkKCg== --===============3676792035190847458==--