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 1ro6Ck-00H4D2-4o for pgsql-bugs@arkaria.postgresql.org; Sat, 23 Mar 2024 18:34:54 +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 1ro6Ci-00AivM-42 for pgsql-bugs@arkaria.postgresql.org; Sat, 23 Mar 2024 18:34:52 +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 1ro5nt-00AfVZ-OQ for pgsql-bugs@lists.postgresql.org; Sat, 23 Mar 2024 18:09:14 +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 1ro5nl-0063gJ-IU for pgsql-bugs@lists.postgresql.org; Sat, 23 Mar 2024 18:09:12 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=ZLh8XiIZmkhG3K9Eihyq+gLPTRJFVd+XQUfFwexGEPM=; b=FTb/HctgWoEtHpURisZK/xWS8O BPIGW16hWabFIqcT5+3borZLCrq5G0C00w6wtgGBcpDi1RSwKIxBousxDXH/FRGihFTMp0IXSrwYW X3zsiEYE83x1TKEoQcHfcgFuGyTaUvgcoVbJ1ZKqVt6n5Um4Li3ucEufMEfQn/BzMUPuj/AMreEYs zte4JfZMyT1MyttNr1s507bGd0aqcl2ibKzvsNXmioPUsMxlTxmAn4LqC66ikVbsylxI2A8fjkwUu Tl6iCzQjXt7qBW4HhvfzXZZPFjgCAgSzs0RIdDQh8c27WHthz5OM8Z2Q2e+GA/6Fp6OpGWcFAii0r 4AqzWxnA==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ro5nl-00GhAz-Ni for pgsql-bugs@lists.postgresql.org; Sat, 23 Mar 2024 18:09:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ro5ni-006b1U-6a for pgsql-bugs@lists.postgresql.org; Sat, 23 Mar 2024 18:09:03 +0000 Content-Type: multipart/mixed; boundary="===============7166428409178319750==" MIME-Version: 1.0 Subject: BUG #18405: flaw in dump of inherited/dropped constraints To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: scott_ribe@elevated-dev.com Reply-To: scott_ribe@elevated-dev.com, pgsql-bugs@lists.postgresql.org Date: Sat, 23 Mar 2024 18:09:02 +0000 Message-ID: <18405-4ce10e802e8d3174@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7166428409178319750== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODQwNQpMb2dnZWQgYnk6ICAgICAgICAgIHNyaWJlCkVtYWlsIGFkZHJl c3M6ICAgICAgc2NvdHRfcmliZUBlbGV2YXRlZC1kZXYuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTYuMgpPcGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4ICZhbXA7IG1hY09TCkRlc2NyaXB0aW9uOiAg ICAgICAgCgpDcmVhdGUgdGhlIGZvbGxvd2luZyBzY2hlbWE6DQoNCmNyZWF0ZSB0YWJsZSB0MSAo YyBib29sZWFuIG5vdCBudWxsKTsNCmNyZWF0ZSB0YWJsZSB0MiAoYyBib29sZWFuKSBpbmhlcml0 cyAodDEpOw0KYWx0ZXIgdGFibGUgdDIgYWx0ZXIgYyBkcm9wIG5vdCBudWxsOw0KDQotLS0tLS0g DQpDaGVjayBpdDoNCg0KdGVzdD0jIFxkIHQyDQogICAgICAgICAgICAgICAgIFRhYmxlICJwdWJs aWMudDIiDQogQ29sdW1uIHwgIFR5cGUgICB8IENvbGxhdGlvbiB8IE51bGxhYmxlIHwgRGVmYXVs dA0KLS0tLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tDQog YyAgICAgIHwgYm9vbGVhbiB8ICAgICAgICAgICB8ICAgICAgICAgIHwNCkluaGVyaXRzOiB0MQ0K DQotLS0tLS0gDQpEdW1wIGl0OiANCg0K4p2vIHBnX2R1bXAgLXMgLXQgdDEgLXQgdDIgdGVzdA0K LS0NCi0tIFBvc3RncmVTUUwgZGF0YWJhc2UgZHVtcA0KLS0NCg0KLS0gRHVtcGVkIGZyb20gZGF0 YWJhc2UgdmVyc2lvbiAxNC4yDQotLSBEdW1wZWQgYnkgcGdfZHVtcCB2ZXJzaW9uIDE2LjINCg0K U0VUIC4uLg0KDQpDUkVBVEUgVEFCTEUgcHVibGljLnQxICgNCiAgICBjIGJvb2xlYW4gTk9UIE5V TEwNCik7DQoNCkFMVEVSIFRBQkxFIHB1YmxpYy50MSBPV05FUiBUTyBzcmliZTsNCg0KQ1JFQVRF IFRBQkxFIHB1YmxpYy50MiAoDQogICAgYyBib29sZWFuDQopDQpJTkhFUklUUyAocHVibGljLnQx KTsNCg0KDQpBTFRFUiBUQUJMRSBwdWJsaWMudDIgT1dORVIgVE8gc3JpYmU7DQoNCi0tLS0tLSAN ClRoZSBkcm9wIG9mIHRoZSBub3QgbnVsbCBjb25zdHJhaW50IGlzIG5vdCByZWZsZWN0ZWQgaW4g dGhlIGR1bXAuIFRodXMKcGxheWluZyBiYWNrIHRoZSBkdW1wIHJlc3VsdHMgaW4gY29sdW1uIGMg b2YgdGFibGUgdDIgaGF2aW5nIHRoZSBub3QgbnVsbApjb25zdHJhaW50Lg0KDQpCdXQgaXQncyBh Y3R1YWxseSBhIGJpdCB3ZWlyZGVyIHRoYW4gdGhhdC4gSSBoYXZlIGJlZW4gdXNpbmc6DQoNCnBn X2R1bXAgLUZjIC1aMCBteWRiIHwgYnppcDIgPiA8ZmlsZW5hbWU+DQoNCmZvbGxvd2VkIGJ5Og0K DQpidW56aXAyIC1rYyA8ZmlsZW5hbWU+IHwgcGdfcmVzdG9yZSAtdiAtZCBteWRiDQoNCnRvIGxv YWQgdXAgYSB0ZXN0aW5nIGNvcHkgZm9yIGEgdmVyeSBsb25nIHRpbWUuIFRoaXMgd29ya2VkIGZy b20gcHJldHR5IG9sZAp2ZXJzaW9ucyBhbGwgdGhlIHdheSB0aHJvdWdoIDE1LCBidXQgYnJva2Ug aW4gMTYgYmVjYXVzZSBvZiB0aGUgZXJyb25lb3VzCm5vdCBudWxsIGNvbnN0cmFpbnQgb24gYSB0 YWJsZS4gWWV0IGdvaW5nIGJhY2sgdG8gMTQuMiAoSSBkb24ndCBjdXJyZW50bHkKaGF2ZSAxNSBp bnN0YWxsZWQgbG9jYWxseSksIHRoZSBwbGFpbiBmb3JtYXQgZHVtcCBoYXMgdGhlIHByb2JsZW0g b2Ygbm90CmRyb3BwaW5nIHRoZSBjb25zdHJhaW50LiBTbyBpdCBsb29rcyBsaWtlIHByaW9yIHRv IDE2LCBwbGFpbiBkdW1wcyBoYWQgdGhpcwpwcm9ibGVtLCBidXQgY3VzdG9tIGZvcm1hdCBkdW1w cyBkaWQgbm90Lg0KDQpPbmUgbW9yZSB0aGluZywgbWFraW5nIHRoZSBjdXN0b20gZm9ybWF0IGR1 bXAgdXNpbmcgcGdfZHVtcCAxNCwgdGhlbgpyZXN0b3Jpbmcgd2l0aCBwZ19yZXN0b3JlIDE2LCBn ZXRzIHRoZSBlcnJvbmVvdXMgbm90IG51bGwgY29uc3RyYWludC4gKER1bXAKd2l0aCAxNiBhbmQg cmVzdG9yZSB3aXRoIDE0LCBpcyBvZiBjb3Vyc2Ugbm90IHBvc3NpYmxlLikNCg0KUEcgYnVpbGRz IGFyZSBub3RoaW5nIGV4b3RpYy4gTGludXg6IC4vY29uZmlndXJlIC0td2l0aC1vcGVuc3NsCi0t d2l0aC1zeXN0ZW1kIC0td2l0aC1sbHZtIC0tcHJlZml4PS4uLiwgbWFjT1M6IC4vY29uZmlndXJl IC0td2l0aG91dC1pY3UKLS13aXRoLWxsdm0gLS1wcmVmaXg9Li4uCgo= --===============7166428409178319750==--