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 1u7cZ7-002dCN-PW for pgsql-committers@arkaria.postgresql.org; Wed, 23 Apr 2025 16:03:14 +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 1u7cZ5-007ZTB-B8 for pgsql-committers@arkaria.postgresql.org; Wed, 23 Apr 2025 16:03:12 +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 1u7cZ5-007ZT3-3s for pgsql-committers@lists.postgresql.org; Wed, 23 Apr 2025 16:03:11 +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 1u7cZ3-001YiV-1w for pgsql-committers@lists.postgresql.org; Wed, 23 Apr 2025 16:03:11 +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 1u7cZ2-004OGc-MG for pgsql-committers@lists.postgresql.org; Wed, 23 Apr 2025 16:03:09 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1u7cZ2-001Qcm-2H for pgsql-committers@lists.postgresql.org; Wed, 23 Apr 2025 16:03:09 +0000 Content-Type: multipart/mixed; boundary="===============4036100581086224489==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Change the names generated for child foreign key constraints. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 23 Apr 2025 16:03:09 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4036100581086224489== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Q2hhbmdlIHRoZSBuYW1lcyBnZW5lcmF0ZWQgZm9yIGNoaWxkIGZvcmVpZ24ga2V5IGNvbnN0cmFp bnRzLgoKV2hlbiBhIGZvcmVpZ24ga2V5IGNvbnN0cmFpbnQgaXMgcGxhY2VkIG9uIGEgcGFydGl0 aW9uZWQgdGFibGUsIHdlCmFjdHVhbGx5IG1ha2UgdHdvIHBnX2NvbnN0cmFpbnQgZW50cmllcyBh c3NvY2lhdGVkIHdpdGggdGhhdCB0YWJsZS4KKEkgaGF2ZSBteSBkb3VidHMgYWJvdXQgdGhlIHdp c2RvbSBvZiB0aGF0LCBidXQgaXQncyBiZWVuIGxpa2UgdGhhdApzaW5jZSB2MTIgYW5kIHBvc3Qt ZmVhdHVyZS1mcmVlemUgaXMgbm8gdGltZSB0byBiZSBtZXNzaW5nIHdpdGggc3VjaAplbnRyZW5j aGVkIGRlY2lzaW9ucy4pICBUaGUgc2Vjb25kICJjaGlsZCIgZW50cnkgYWx3YXlzIGhhZCBhIG5h bWUKZ2VuZXJhdGVkIGFjY29yZGluZyB0byB0aGUgZGVmYXVsdCBydWxlLCAidGFibGVfY29sdW1u KHMpX2ZrZXlbbm5uXSIsCmV2ZW4gaWYgdGhlIHByaW1hcnkgZW50cnkgaGFkIGFuIHVucmVsYXRl ZCB1c2VyLXNwZWNpZmllZCBuYW1lLiAgVGhlCnRyb3VibGUgd2l0aCBkb2luZyB0aGF0IGlzIHRo YXQgdGhlIGRlZmF1bHQgbmFtZSBjb3VsZCBjb2xsaWRlIHdpdGgKdGhlIHVzZXItc3BlY2lmaWVk IG5hbWUgb2Ygc29tZSBvdGhlciBjb25zdHJhaW50IG9uIHRoZSBzYW1lIHRhYmxlLgpXaGlsZSB3 ZSB3ZXJlIHdpbGxpbmcgdG8gYWRqdXN0IHRoZSBnZW5lcmF0ZWQgbmFtZSB0byBhdm9pZApjb2xs aXNpb25zLCB0aGF0IG9ubHkgaGVscHMgaWYgaXQncyBtYWRlIHNlY29uZDsgaWYgaXQncyBtYWRl IGZpcnN0CnRoZW4gY3JlYXRpb24gb2YgdGhlIG90aGVyIGNvbnN0cmFpbnQgd291bGQgZmFpbCwg cG90ZW50aWFsbHkgY2F1c2luZwpkdW1wL3JlbG9hZCBvciBwZ191cGdyYWRlIGZhaWx1cmVzLgoK VGhlIGNvcmUgb2YgdGhlIHByb2JsZW0gaGVyZSBpcyB0aGF0IHdlJ3JlIGluZnJpbmdpbmcgb24g dXNlcgpuYW1lc3BhY2UsIHNvIEkgZG91YnQgdGhhdCB0aGVyZSdzIGFueSAxMDAlIHNvbHV0aW9u IG90aGVyIHRoYW4gdG8KZmluZCBhIHdheSB0byBub3QgbmVlZCB0aGUgImNoaWxkIiBlbnRyeS4g IEluIHRoZSBtZWFudGltZSwgaXQgc2VlbXMKbGlrZSBpdCdkIGJlIGFuIGltcHJvdmVtZW50IHRv IG1ha2UgdGhlIGNoaWxkJ3MgbmFtZSBiZSB0aGUgbmFtZSBvZgp0aGUgcGFyZW50IGNvbnN0cmFp bnQgd2l0aCBhbiB1bmRlcnNjb3JlIGFuZCBkaWdpdChzKSBhcHBlbmRlZCBhcwpuZWNlc3Nhcnkg dG8gbWFrZSBpdCB1bmlxdWUuICBUaGlzIHJ1bGUgY2FuIGluIHRoZW9yeSBmYWlsIGluIHRoZSBz YW1lCndheSwgYnV0IGl0IHNlZW1zIG11Y2ggbGVzcyBwcm9iYWJsZTsgZm9yIG9uZSB0aGluZywg dGhpcyBydWxlIGlzCmd1YXJhbnRlZWQgbm90IHRvIG1hdGNoIHByaW1hcnkgZW50cmllcyBoYXZp bmcgYXV0by1nZW5lcmF0ZWQgbmFtZXMuCihXaGlsZSBhbiBhdXRvLWdlbmVyYXRlZCBwcmltYXJ5 IG5hbWUgaXNuJ3QgdXNlci1zcGVjaWZpZWQgdG8gYmVnaW4Kd2l0aCwgaXQgYWN0cyBsaWtlIHRo YXQgZHVyaW5nIGR1bXAvcmVsb2FkLCBzbyBjb2xsaXNpb25zIGFnYWluc3Qgc3VjaApuYW1lcyBh cmUgZGVmaW5pdGVseSBwb3NzaWJsZS4pCgpBbiBhZGRpdGlvbmFsIGJvbnVzLCB2aXNpYmxlIGlu IHNvbWUgb2YgdGhlIHJlZ3Jlc3Npb24gdGVzdCBjYXNlcwp0aGF0IGNoYW5nZSBoZXJlLCBhcmlz ZXMgZnJvbSB0aGUgZmFjdCB0aGF0IHNvbWUgZXJyb3IgbWVzc2FnZXMKY2l0ZSB0aGUgY2hpbGQg Y29uc3RyYWludCdzIG5hbWUgbm90IHRoZSBwYXJlbnQncy4gIEluIHRoZQpwcmV2aW91cyBhcHBy b2FjaCB0aGUgdHdvIG5hbWVzIGNvdWxkIGJlIGNvbXBsZXRlbHkgdW5yZWxhdGVkLApsZWFkaW5n IHRvIHVzZXIgY29uZnVzaW9uIC0tLSB0aGUgbW9yZSBzbyBzaW5jZSBwc3FsJ3MgXGQgY29tbWFu ZApoaWRlcyBjaGlsZCBjb25zdHJhaW50cy4gIFdpdGggdGhpcyBhcHByb2FjaCBpdCdzIGhvcGVm dWxseSBtdWNoCmNsZWFyZXIgd2hpY2ggY29uc3RyYWludC10aGUtdXNlci1rbm93cy1hYm91dCBp cyBmYWlsaW5nLgoKSG93ZXZlciwgdGhhdCBkb2VzIG1lYW4gdGhhdCB0aGVyZSdzIHVzZXItdmlz aWJsZSBiZWhhdmlvciBjaGFuZ2UKb2NjdXJyaW5nIGhlcmUsIG1ha2luZyBpdCBzZWVtIGxpa2Ug bm90IHNvbWV0aGluZyB0byBiYWNrLXBhdGNoLgpJIGZlZWwgaXQncyBub3QgdG9vIGxhdGUgZm9y IHYxOCwgdGhvdWdoLgoKUmVwb3J0ZWQtYnk6IEtpcmlsbCBSZXNoa2UgPHJlc2hrZWtpcmlsbEBn bWFpbC5jb20+CkF1dGhvcjogVG9tIExhbmUgPHRnbEBzc3MucGdoLnBhLnVzPgpSZXZpZXdlZC1i eTogQWx2YXJvIEhlcnJlcmEgPGFsdmhlcnJlQGt1cmlsZW11LmRlPgpEaXNjdXNzaW9uOiBodHRw czovL3Bvc3Rnci5lcy9tL0NBTGRTU1BoR2l0anBUZnpFTUpOLVkyeCtRLTVRQ2hTeEFzbVNKMS1F OG1RSkxrSE9xUUBtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMK LS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzNkYjYxZGI0 OGVmNWI4ODk4ZjdlODVmOTg1NDhmZGVjNzlkNzY1MjQKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0t LS0tLS0tCnNyYy9iYWNrZW5kL2NhdGFsb2cvcGdfY29uc3RyYWludC5jICAgICAgICAgICAgICAg IHwgIDkgKystCnNyYy9iYWNrZW5kL2NvbW1hbmRzL3RhYmxlY21kcy5jICAgICAgICAgICAgICAg ICAgIHwgMTAgKy0tCi4uLi9leHBlY3RlZC9kZXRhY2gtcGFydGl0aW9uLWNvbmN1cnJlbnRseS0y Lm91dCAgIHwgIDIgKy0KLi4uL2V4cGVjdGVkL2RldGFjaC1wYXJ0aXRpb24tY29uY3VycmVudGx5 LTQub3V0ICAgfCAgMiArLQpzcmMvdGVzdC9pc29sYXRpb24vZXhwZWN0ZWQvZmstcGFydGl0aW9u ZWQtMS5vdXQgICB8IDE0ICsrLS0Kc3JjL3Rlc3QvaXNvbGF0aW9uL2V4cGVjdGVkL2ZrLXBhcnRp dGlvbmVkLTIub3V0ICAgfCAgNCArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2NvbnN0cmFp bnRzLm91dCAgICAgICAgICB8ICA2ICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvZm9yZWln bl9rZXkub3V0ICAgICAgICAgIHwgODIgKysrKysrKysrKystLS0tLS0tLS0tLQpzcmMvdGVzdC9y ZWdyZXNzL2V4cGVjdGVkL3dpdGhvdXRfb3ZlcmxhcHMub3V0ICAgICB8ICA4ICstLQpzcmMvdGVz dC9yZWdyZXNzL3NxbC9mb3JlaWduX2tleS5zcWwgICAgICAgICAgICAgICB8ICA0ICstCjEwIGZp bGVzIGNoYW5nZWQsIDc0IGluc2VydGlvbnMoKyksIDY3IGRlbGV0aW9ucygtKQoK --===============4036100581086224489==--