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-00BWQw-Vg 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-00Fbhs-ET for pgsql-committers@arkaria.postgresql.org; Tue, 17 Sep 2024 19:56:20 +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-00FYbN-Tt 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-001gkB-Lw 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 1sqeGj-005Rsu-3g 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-001Y7w-AN for pgsql-committers@lists.postgresql.org; Tue, 17 Sep 2024 19:53:48 +0000 Content-Type: multipart/mixed; boundary="===============3417656423938731757==" 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 --===============3417656423938731757== 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 bC5vcmcKCkJyYW5jaAotLS0tLS0KUkVMXzE1X1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBz Oi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvZmMyZDFhYzFhZDQ0YjVjMDNlMGU4 ZWRmMGY5ZWIwZTNmNDJjYWRhNAoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0KZG9jL3Ny Yy9zZ21sL3JlZi9jcmVhdGVfdGFibGUuc2dtbCAgICAgfCAxNyArKysrKy0tLQpzcmMvYmFja2Vu ZC9jb21tYW5kcy9zZXF1ZW5jZS5jICAgICAgICB8ICA1ICsrLQpzcmMvYmFja2VuZC9wYXJzZXIv Z3JhbS55ICAgICAgICAgICAgICB8ICA5ICsrKy0Kc3JjL2JhY2tlbmQvcGFyc2VyL3BhcnNlX3V0 aWxjbWQuYyAgICAgfCA4MCArKysrKysrKysrKysrKysrKysrKysrKy0tLS0tLS0tLS0tCnNyYy9i aW4vcGdfZHVtcC9wZ19kdW1wLmMgICAgICAgICAgICAgIHwgMTcgKysrKy0tLS0Kc3JjL3Rlc3Qv cmVncmVzcy9leHBlY3RlZC9pZGVudGl0eS5vdXQgfCAxNiArKysrKysrCnNyYy90ZXN0L3JlZ3Jl c3Mvc3FsL2lkZW50aXR5LnNxbCAgICAgIHwgIDkgKysrKwo3IGZpbGVzIGNoYW5nZWQsIDExMiBp bnNlcnRpb25zKCspLCA0MSBkZWxldGlvbnMoLSkKCg== --===============3417656423938731757==--