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 1sqeJA-00BWQv-V5 for pgsql-committers@arkaria.postgresql.org; Tue, 17 Sep 2024 19:56:21 +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 1sqeJA-00Fbhp-EQ for pgsql-committers@arkaria.postgresql.org; Tue, 17 Sep 2024 19:56:20 +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 1sqeGn-00FYbM-7B 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 magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sqeGj-001hPk-3h for pgsql-committers@lists.postgresql.org; Tue, 17 Sep 2024 19:53:52 +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 1sqeGi-005Rsq-ON for pgsql-committers@lists.postgresql.org; Tue, 17 Sep 2024 19:53:48 +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-001Y7u-9o for pgsql-committers@lists.postgresql.org; Tue, 17 Sep 2024 19:53:48 +0000 Content-Type: multipart/mixed; boundary="===============3974847056116777978==" 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 --===============3974847056116777978== 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 bC5vcmcKCkJyYW5jaAotLS0tLS0KUkVMXzE2X1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBz Oi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvYjhiMTc1YTRjODk1MTlkYzIyYWQ3 MDZkNjg1YWMyZjBiZTUzYmQ4OAoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0KZG9jL3Ny Yy9zZ21sL3JlZi9jcmVhdGVfdGFibGUuc2dtbCAgICAgfCAxNyArKysrKy0tLQpzcmMvYmFja2Vu ZC9jb21tYW5kcy9zZXF1ZW5jZS5jICAgICAgICB8ICA1ICsrLQpzcmMvYmFja2VuZC9wYXJzZXIv Z3JhbS55ICAgICAgICAgICAgICB8ICA5ICsrKy0Kc3JjL2JhY2tlbmQvcGFyc2VyL3BhcnNlX3V0 aWxjbWQuYyAgICAgfCA4MCArKysrKysrKysrKysrKysrKysrKysrKy0tLS0tLS0tLS0tCnNyYy9i aW4vcGdfZHVtcC9wZ19kdW1wLmMgICAgICAgICAgICAgIHwgMTcgKysrKy0tLS0Kc3JjL3Rlc3Qv cmVncmVzcy9leHBlY3RlZC9pZGVudGl0eS5vdXQgfCAxNiArKysrKysrCnNyYy90ZXN0L3JlZ3Jl c3Mvc3FsL2lkZW50aXR5LnNxbCAgICAgIHwgIDkgKysrKwo3IGZpbGVzIGNoYW5nZWQsIDExMiBp bnNlcnRpb25zKCspLCA0MSBkZWxldGlvbnMoLSkKCg== --===============3974847056116777978==--