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 1uVwJV-006DTG-Ib for pgsql-committers@arkaria.postgresql.org; Sun, 29 Jun 2025 17:59:37 +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 1uVwJT-00CS0B-KO for pgsql-committers@arkaria.postgresql.org; Sun, 29 Jun 2025 17:59:36 +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 1uVwGO-00CPOH-6n for pgsql-committers@lists.postgresql.org; Sun, 29 Jun 2025 17:56:24 +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.96) (envelope-from ) id 1uVwGL-004lbK-2u for pgsql-committers@lists.postgresql.org; Sun, 29 Jun 2025 17:56:24 +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 1uVwGK-00D39M-13 for pgsql-committers@lists.postgresql.org; Sun, 29 Jun 2025 17:56:20 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uVwGJ-003uh1-0k for pgsql-committers@lists.postgresql.org; Sun, 29 Jun 2025 17:56:19 +0000 Content-Type: multipart/mixed; boundary="===============2311160525064910796==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Obtain required table lock during cross-table constraint updates X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sun, 29 Jun 2025 17:56:19 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2311160525064910796== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 T2J0YWluIHJlcXVpcmVkIHRhYmxlIGxvY2sgZHVyaW5nIGNyb3NzLXRhYmxlIGNvbnN0cmFpbnQg dXBkYXRlcy4KClNvbWV0aW1lcyBhIHRhYmxlJ3MgY29uc3RyYWludCBtYXkgZGVwZW5kIG9uIGEg Y29sdW1uIG9mIGFub3RoZXIKdGFibGUsIHNvIHRoYXQgd2UgaGF2ZSB0byB1cGRhdGUgdGhlIGNv bnN0cmFpbnQgd2hlbiBjaGFuZ2luZyB0aGUKcmVmZXJlbmNlZCBjb2x1bW4ncyB0eXBlLiAgV2Ug bmVlZCB0byBoYXZlIGxvY2sgb24gdGhlIGNvbnN0cmFpbnQncwp0YWJsZSB0byBkbyB0aGF0LiAg QVRQb3N0QWx0ZXJUeXBlQ2xlYW51cCBiZWxpZXZlZCB0aGF0IHRoaXMgY2FzZQp3YXMgb25seSBw b3NzaWJsZSBmb3IgRk9SRUlHTiBLRVkgY29uc3RyYWludHMsIGJ1dCBpdCdzIHdyb25nIGF0Cmxl YXN0IGZvciBDSEVDSyBhbmQgRVhDTFVERSBjb25zdHJhaW50czsgYW5kIGluIGdlbmVyYWwsIHdl J2QKcHJvYmFibHkgbmVlZCBleGNsdXNpdmUgbG9jayB0byBhbHRlciBhbnkgc29ydCBvZiBjb25z dHJhaW50LgpTbyBqdXN0IHJlbW92ZSB0aGUgY29udHlwZSBjaGVjayBhbmQgYWNxdWlyZSBsb2Nr IGZvciBhbnkgb3RoZXIKdGFibGUuICBUaGlzIHByZXZlbnRzIGEgInlvdSBkb24ndCBoYXZlIGxv Y2siIGFzc2VydGlvbiBmYWlsdXJlLAp0aG91Z2ggbm8gaWxsIGVmZmVjdCBpcyBvYnNlcnZlZCBp biBwcm9kdWN0aW9uIGJ1aWxkcy4KCldlJ2xsIGVycm9yIG91dCBsYXRlciBhbnl3YXkgYmVjYXVz ZSB3ZSBkb24ndCBwcmVzZW50bHkgc3VwcG9ydApwaHlzaWNhbGx5IGFsdGVyaW5nIGNvbHVtbiB0 eXBlcyB3aXRoaW4gc3RvcmVkIGNvbXBvc2l0ZSBjb2x1bW5zLgpCdXQgdGhlIGNhdGFsb2ctbXVu Z2luZyBpcyBiYXNpY2FsbHkgYWxsIHRoZXJlLCBzbyB3ZSBtYXkgYXMgd2VsbAptYWtlIHRoYXQg cGFydCB3b3JrLgoKQnVnOiAjMTg5NzAKUmVwb3J0ZWQtYnk6IEFsZXhhbmRlciBMYWtoaW4gPGV4 Y2x1c2lvbkBnbWFpbC5jb20+CkRpYWdub3NlZC1ieTogamlhbiBoZSA8amlhbi51bml2ZXJzYWxp dHlAZ21haWwuY29tPgpBdXRob3I6IFRvbSBMYW5lIDx0Z2xAc3NzLnBnaC5wYS51cz4KRGlzY3Vz c2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8xODk3MC1hN2QxY2ZlMWY4ZDVkOGQ5QHBvc3RncmVz cWwub3JnCkJhY2twYXRjaC10aHJvdWdoOiAxMwoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFp bHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzgzMTll NWNiNTQ5MzA0NmU2NWQ2MGRhM2NjMTdhYjc4YzkxNzQ5YjEKCk1vZGlmaWVkIEZpbGVzCi0tLS0t LS0tLS0tLS0tCnNyYy9iYWNrZW5kL2NvbW1hbmRzL3RhYmxlY21kcy5jICAgICAgICAgIHwgMjEg KysrKysrKysrKystLS0tLS0tLS0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvYWx0ZXJfdGFi bGUub3V0IHwgIDcgKysrKysrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9hbHRlcl90YWJsZS5zcWwg ICAgICB8ICA5ICsrKysrKysrKwozIGZpbGVzIGNoYW5nZWQsIDI3IGluc2VydGlvbnMoKyksIDEw IGRlbGV0aW9ucygtKQoK --===============2311160525064910796==--