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 1sqeGn-00BVxw-P8 for pgsql-committers@arkaria.postgresql.org; Tue, 17 Sep 2024 19:53:54 +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 1sqeGn-00FYba-Aj for pgsql-committers@arkaria.postgresql.org; Tue, 17 Sep 2024 19:53:53 +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 1sqeGn-00FYbK-3T for pgsql-committers@lists.postgresql.org; Tue, 17 Sep 2024 19:53:53 +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 1sqeGj-001gkA-LA for pgsql-committers@lists.postgresql.org; Tue, 17 Sep 2024 19:53:51 +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 1sqeGj-005Rsr-3d for pgsql-committers@lists.postgresql.org; Tue, 17 Sep 2024 19:53:49 +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 1sqeGi-001Y7q-79 for pgsql-committers@lists.postgresql.org; Tue, 17 Sep 2024 19:53:48 +0000 Content-Type: multipart/mixed; boundary="===============6136970758382758032==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Repair pg_upgrade for identity sequences with non-default persis X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 17 Sep 2024 19:53:48 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6136970758382758032== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UmVwYWlyIHBnX3VwZ3JhZGUgZm9yIGlkZW50aXR5IHNlcXVlbmNlcyB3aXRoIG5vbi1kZWZhdWx0 IHBlcnNpc3RlbmNlLgoKU2luY2Ugd2UgaW50cm9kdWNlZCB1bmxvZ2dlZCBzZXF1ZW5jZXMgaW4g djE1LCBpZGVudGl0eSBzZXF1ZW5jZXMKaGF2ZSBkZWZhdWx0ZWQgdG8gaGF2aW5nIHRoZSBzYW1l IHBlcnNpc3RlbmNlIGFzIHRoZWlyIG93bmluZyB0YWJsZS4KSG93ZXZlciwgaXQgaXMgcG9zc2li bGUgdG8gY2hhbmdlIHRoYXQgd2l0aCBBTFRFUiBTRVFVRU5DRSwgYW5kCnBnX2R1bXAgdHJpZXMg dG8gcHJlc2VydmUgdGhlIGxvZ2dlZC1uZXNzIG9mIHNlcXVlbmNlcyB3aGVuIGl0IGRvZXNuJ3QK bWF0Y2ggKGFzIGluZGVlZCBpdCB3b3VsZG4ndCBmb3IgYW4gdW5sb2dnZWQgdGFibGUgZnJvbSBi ZWZvcmUgdjE1KS4KClRoZSBmbHkgaW4gdGhlIG9pbnRtZW50IGlzIHRoYXQgQUxURVIgU0VRVUVO Q0UgU0VUIFtVTl1MT0dHRUQgZmFpbHMKaW4gYmluYXJ5LXVwZ3JhZGUgbW9kZSwgYmVjYXVzZSBp dCBuZWVkcyB0byBhc3NpZ24gYSBuZXcgcmVsZmlsZW5vZGUKd2hpY2ggd2UgY2Fubm90IHBlcm1p dCBpbiB0aGF0IG1vZGUuICBUaHVzLCB0cnlpbmcgdG8gcGdfdXBncmFkZSBhCmRhdGFiYXNlIGNv bnRhaW5pbmcgYSBtaXNtYXRjaGluZyBpZGVudGl0eSBzZXF1ZW5jZSBmYWlsZWQuCgpUbyBmaXgs IGFkZCBzeW50YXggdG8gQUREL0FMVEVSIENPTFVNTiBHRU5FUkFURUQgQVMgSURFTlRJVFkgdG8g YWxsb3cKdGhlIHNlcXVlbmNlJ3MgcGVyc2lzdGVuY2UgdG8gYmUgc2V0IGNvcnJlY3RseSBhdCBj cmVhdGlvbiwgYW5kIHVzZQp0aGF0IGluc3RlYWQgb2YgQUxURVIgU0VRVUVOQ0UgU0VUIFtVTl1M T0dHRUQgaW4gcGdfZHVtcC4gIChJIHRyaWVkIHRvCm1ha2UgU0VUIFtVTl1MT0dHRUQgd29yayB3 aXRob3V0IGFueSBwZ19kdW1wIG1vZGlmaWNhdGlvbnMsIGJ1dCB0aGF0CnNlZW1zIHRvbyBmcmFn aWxlIHRvIGJlIGEgZGVzaXJhYmxlIGFuc3dlci4gIFRoaXMgd2F5IHNob3VsZCBiZQptYXJrZWRs eSBmYXN0ZXIgYW55aG93LikKCkluIHBhc3NpbmcsIGRvY3VtZW50IHRoZSBwcmV2aW91c2x5LXVu ZG9jdW1lbnRlZCBTRVFVRU5DRSBOQU1FIG9wdGlvbgp0aGF0IHBnX2R1bXAgYWxzbyByZWxpZXMg b24gZm9yIGlkZW50aXR5IHNlcXVlbmNlczsgSSBzZWUgbm8gdmFsdWUKaW4gdHJ5aW5nIHRvIHBy ZXRlbmQgaXQgZG9lc24ndCBleGlzdC4KClBlciBidWcgIzE4NjE4IGZyb20gQW50aG9ueSBIc3Uu CkJhY2stcGF0Y2ggdG8gdjE1IHdoZXJlIHdlIGludmVudGVkIHRoaXMgc3R1ZmYuCgpEaXNjdXNz aW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzE4NjE4LWQ0ZWIyNmQ2NjllZDExMGFAcG9zdGdyZXNx bC5vcmcKCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQu cG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi85MThlMjFkMjUxNzhjOGFlMDk4MDhjNTgxYTc4 MjAwMmY3MDJlZDllCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpkb2Mvc3JjL3NnbWwv cmVmL2NyZWF0ZV90YWJsZS5zZ21sICAgICB8IDE3ICsrKysrLS0tCnNyYy9iYWNrZW5kL2NvbW1h bmRzL3NlcXVlbmNlLmMgICAgICAgIHwgIDUgKystCnNyYy9iYWNrZW5kL3BhcnNlci9ncmFtLnkg ICAgICAgICAgICAgIHwgIDkgKysrLQpzcmMvYmFja2VuZC9wYXJzZXIvcGFyc2VfdXRpbGNtZC5j ICAgICB8IDgwICsrKysrKysrKysrKysrKysrKysrKysrLS0tLS0tLS0tLS0Kc3JjL2Jpbi9wZ19k dW1wL3BnX2R1bXAuYyAgICAgICAgICAgICAgfCAxNyArKysrLS0tLQpzcmMvdGVzdC9yZWdyZXNz L2V4cGVjdGVkL2lkZW50aXR5Lm91dCB8IDE2ICsrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwv aWRlbnRpdHkuc3FsICAgICAgfCAgOSArKysrCjcgZmlsZXMgY2hhbmdlZCwgMTEyIGluc2VydGlv bnMoKyksIDQxIGRlbGV0aW9ucygtKQoK --===============6136970758382758032==--