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 1sYT5N-00Back-O9 for pgsql-committers@arkaria.postgresql.org; Mon, 29 Jul 2024 16:18:57 +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 1sYT5M-000tNv-8V for pgsql-committers@arkaria.postgresql.org; Mon, 29 Jul 2024 16:18:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sYT4B-000rgl-3e for pgsql-committers@lists.postgresql.org; Mon, 29 Jul 2024 16:17:43 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sYT44-0025pa-Gm for pgsql-committers@lists.postgresql.org; Mon, 29 Jul 2024 16:17:42 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sYT42-006TFw-Vs for pgsql-committers@lists.postgresql.org; Mon, 29 Jul 2024 16:17:34 +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 1sYT42-001lYa-B1 for pgsql-committers@lists.postgresql.org; Mon, 29 Jul 2024 16:17:34 +0000 Content-Type: multipart/mixed; boundary="===============4827489286626233775==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Reduce number of commands dumpTableSchema emits for binary upgra X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 29 Jul 2024 16:17:34 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4827489286626233775== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UmVkdWNlIG51bWJlciBvZiBjb21tYW5kcyBkdW1wVGFibGVTY2hlbWEgZW1pdHMgZm9yIGJpbmFy eSB1cGdyYWRlLgoKQXZvaWQgaXNzdWluZyBhIHNlcGFyYXRlIFNRTCBVUERBVEUgY29tbWFuZCBm b3IgZWFjaCBjb2x1bW4gd2hlbgpkaXJlY3RseSBtYW5pcHVsYXRpbmcgcGdfYXR0cmlidXRlIGNv bnRlbnRzIGluIGJpbmFyeSB1cGdyYWRlIG1vZGUuCldpdGggdGhlIHNlcGFyYXRlIHVwZGF0ZXMs IHdlIHRyaWdnZXJlZCBhIHJlbGNhY2hlIGludmFsaWRhdGlvbiB3aXRoCmVhY2ggdXBkYXRlLiAg Rm9yIGEgdGFibGUgd2l0aCBOIGNvbHVtbnMsIHRoYXQgY2F1c2VzIE8oTl4yKSByZWxjYWNoZQpi bG9hdCBpbiB0eG5fc2l6ZSBtb2RlIGJlY2F1c2UgdGhlIHRhYmxlJ3MgbmV3bHktY3JlYXRlZCBy ZWxjYWNoZQplbnRyeSBjYW4ndCBiZSBmbHVzaGVkIHRpbGwgZW5kIG9mIHRyYW5zYWN0aW9uLiAg UmVkdWNpbmcgdGhlIG51bWJlcgpvZiBjb21tYW5kcyBzaG91bGQgbWFrZSBpdCBtYXJnaW5hbGx5 IGZhc3RlciBhcyB3ZWxsIGFzIGF2b2lkaW5nIHRoYXQKcHJvYmxlbS4KCldoaWxlIGF0IGl0LCBs aWtld2lzZSBhdm9pZCBpc3N1aW5nIGEgc2VwYXJhdGUgVVBEQVRFIG9uIHBnX2NvbnN0cmFpbnQK Zm9yIGVhY2ggaW5oZXJpdGVkIGNvbnN0cmFpbnQuICBUaGlzIGlzIGxlc3MgZXhjaXRpbmcsIGZp cnN0IGJlY2F1c2UKaW5oZXJpdGVkIChub24tcGFydGl0aW9uZWQpIGNvbnN0cmFpbnRzIGFyZSBy ZWxhdGl2ZWx5IHJhcmUsIGFuZApzZWNvbmQgYmVjYXVzZSB0aGUgYmFja2VuZCBoYXMgYSBnb29k IGRlYWwgb2YgdHJvdWJsZSBhbnl3YXkgd2l0aApyZXN0b3JpbmcgdGFibGVzIGNvbnRhaW5pbmcg bWFueSBzdWNoIGNvbnN0cmFpbnRzLCBkdWUgdG8KTWVyZ2VDb25zdHJhaW50c0ludG9FeGlzdGlu ZyBiZWluZyBob3JyaWJseSBpbmVmZmljaWVudC4gIEJ1dCBpdCBzZWVtcwptb3JlIGNvbnNpc3Rl bnQgdG8gZG8gaXQgdGhpcyB3YXkgaGVyZSB0b28sIGFuZCBpdCBzdXJlbHkgY2FuJ3QgaHVydC4K CkluIHBhc3NpbmcsIGZpeCBvbmUgcGxhY2UgaW4gZHVtcFRhYmxlU2NoZW1hIHRoYXQgZmFpbGVk IHRvIHVzZSBPTkxZCmluIEFMVEVSIFRBQkxFLiAgVGhhdCdzIG5vdCBhIGxpdmUgYnVnLCBidXQg aXQncyBpbmNvbnNpc3RlbnQuCkFsc28gYXZvaWQgc2lsZW50bHkgY2FzdGluZyBhd2F5IGNvbnN0 IGZyb20gc3RyaW5nIGxpdGVyYWxzLgoKUGVyIHJlcG9ydCBmcm9tIEp1c3RpbiBQcnl6YnkuICBC YWNrLXBhdGNoIHRvIHYxNyB3aGVyZSB0eG5fc2l6ZSBtb2RlCndhcyBpbnRyb2R1Y2VkLgoKRGlz Y3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9acUVORDRaY1REQm1jdjMxQHByeXpieWoyMDIz CgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3Rn cmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvYjNmMGUwNTAzZjMzMzkzOGRmNjM4YThmNDk5OTA5Y2U0 OTAxYjQwYwoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2Jpbi9wZ19kdW1wL3Bn X2R1bXAuYyAgICAgICAgfCAxMzQgKysrKysrKysrKysrKysrKysrKysrKysrKysrKy0tLS0tLS0t LS0tCnNyYy9iaW4vcGdfZHVtcC90LzAwMl9wZ19kdW1wLnBsIHwgICAyICstCjIgZmlsZXMgY2hh bmdlZCwgOTkgaW5zZXJ0aW9ucygrKSwgMzcgZGVsZXRpb25zKC0pCgo= --===============4827489286626233775==--