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-006DTE-PT 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-00CS0D-KG for pgsql-committers@arkaria.postgresql.org; Sun, 29 Jun 2025 17:59:36 +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 1uVwGN-00CP8E-6X for pgsql-committers@lists.postgresql.org; Sun, 29 Jun 2025 17:56:23 +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.96) (envelope-from ) id 1uVwGK-004d3A-2L for pgsql-committers@lists.postgresql.org; Sun, 29 Jun 2025 17:56:22 +0000 Received: from gemulon.postgresql.org ([72.32.157.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-00D39Q-14 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-003uhB-13 for pgsql-committers@lists.postgresql.org; Sun, 29 Jun 2025 17:56:19 +0000 Content-Type: multipart/mixed; boundary="===============8700933284341691413==" 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 --===============8700933284341691413== 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 cWwub3JnCkJhY2twYXRjaC10aHJvdWdoOiAxMwoKQnJhbmNoCi0tLS0tLQpSRUxfMTNfU1RBQkxF CgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlm Zi8xM2YxZTlmMjZhMTEyNjIzYzA3ZjU1Yjg4Yjg3NTMwNjQ5ZDcxNTVkCgpNb2RpZmllZCBGaWxl cwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9jb21tYW5kcy90YWJsZWNtZHMuYyAgICAgICAg ICB8IDIxICsrKysrKysrKysrLS0tLS0tLS0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2Fs dGVyX3RhYmxlLm91dCB8ICA3ICsrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvYWx0ZXJfdGFi bGUuc3FsICAgICAgfCAgOSArKysrKysrKysKMyBmaWxlcyBjaGFuZ2VkLCAyNyBpbnNlcnRpb25z KCspLCAxMCBkZWxldGlvbnMoLSkKCg== --===============8700933284341691413==--