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 1qdWfN-003kkK-VJ for pgsql-bugs@arkaria.postgresql.org; Tue, 05 Sep 2023 14:04:29 +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 1qdWfM-002SUr-Rs for pgsql-bugs@arkaria.postgresql.org; Tue, 05 Sep 2023 14:04:28 +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 1qdW1M-002Foi-53 for pgsql-bugs@lists.postgresql.org; Tue, 05 Sep 2023 13:23:07 +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 1qdW1J-002s6d-0K for pgsql-bugs@lists.postgresql.org; Tue, 05 Sep 2023 13:23:06 +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=c7pZgFeCs3G9XiJq5ekbZgT0+LRvhQkLPgSure8N6ns=; b=KTR9WwXG6DrZNV7M6GnBqfGUED Ksbxr/x6H4wDYF38kjJNYt2Zq2AOBCjxe55ovitVac6+BP3p2lOfFXbOaLN7RsSNGKbtdTD/mRyc2 HgmJ8dp33KOMr27Q6SRDT7tgMfHpudrhAmBDmALAEVFyONOE6fEbvo37T4AS3UrQNSSwwmUqlmYV/ pzc1I9ViMaMwIQgDBh4P+cWCxpgRYK7MyFu7Ps3pyYQ4N8V1bnYObwb0GkGgjK6oldmxlu9k7ihrN G08XJtgmrWOqmYzPxFQP+DB/FPsy3WPTWI6GqWzeTSTRERp6vCmfsarSqvHWuF/vgYUPaMPxI60zD oSgUX6yQ==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qdW1I-00071H-G0 for pgsql-bugs@lists.postgresql.org; Tue, 05 Sep 2023 13:23:04 +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 1qdW1G-009QfE-Sx for pgsql-bugs@lists.postgresql.org; Tue, 05 Sep 2023 13:23:03 +0000 Content-Type: multipart/mixed; boundary="===============4243992334240496615==" MIME-Version: 1.0 Subject: BUG #18089: Orphaned Rows During PostgreSQL Data Migration To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: rootcause000@gmail.com Reply-To: rootcause000@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 05 Sep 2023 13:22:58 +0000 Message-ID: <18089-72525e9fc0926c18@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 --===============4243992334240496615== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODA4OQpMb2dnZWQgYnk6ICAgICAgICAgIFJvb3QgQ2F1c2UKRW1haWwg YWRkcmVzczogICAgICByb290Y2F1c2UwMDBAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog VW5zdXBwb3J0ZWQvVW5rbm93bgpPcGVyYXRpbmcgc3lzdGVtOiAgIE1pY3Jvc29mdCBXaW5kb3dz IFNlcnZlciAyMDE5IFN0YW5kYXJkCkRlc2NyaXB0aW9uOiAgICAgICAgCgpWZXJzaW9uIC0gUG9z dGdyZVNRTCAxMC4yMSwgY29tcGlsZWQgYnkgVmlzdWFsIEMrKyBidWlsZCAxODAwLCA2NC1iaXQN Cg0KUGxhdGZvcm0gLSBXaW5kb3dzDQoNCldoZW4gbWlncmF0aW5nIGRhdGEgZnJvbSBQb3N0Z3Jl U1FMIDEwLjIxIHRvIDE0LjcsIGR1cmluZyB0aGUgZHVtcCBwcm9jZXNzLAp3ZSBlbmNvdW50ZXJl ZCBhbiBpc3N1ZSB3aXRoIG9ycGhhbmVkIHJvd3MuIFVwb24gY2hlY2tpbmcgdGhlIHNvdXJjZQpk YXRhYmFzZSwgd2UgY29uZmlybWVkIHRoYXQgdGhlIHRhYmxlIGhhcyBhbGwgdGhlIG5lY2Vzc2Fy eSBjb25zdHJhaW50cyBpbgpwbGFjZS4gSG93ZXZlciwgaXQgYXBwZWFycyB0aGF0IG9ycGhhbmVk IHJvd3MgYXJlIHN0aWxsIHByZXNlbnQuDQoNCkdlbkRhdGFEQj0+IFxkKyBuZl9pbnR6Ow0KICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgVGFibGUgInB1YmxpYy5uZl9pbnR6 Ig0KICAgICAgQ29sdW1uICAgICAgIHwgIFR5cGUgIHwgQ29sbGF0aW9uIHwgTnVsbGFibGUgfCAg ICAgIERlZmF1bHQgICAgICB8ClN0b3JhZ2UgIHwgU3RhdHMgdGFyZ2V0IHwgRGVzY3JpcHRpb24N Ci0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0t LS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLQ0K ICAgICBpbnR6X2lkICAgICAgIHwgYmlnaW50IHwgICAgICAgICAgIHwgbm90IG51bGwgfCAgICAg ICAgICAgICAgICAgICB8CnBsYWluICAgIHwgICAgICAgICAgICAgIHwNCkluZGV4ZXM6DQogICAg Im5mX2ludHpfcGsiIFBSSU1BUlkgS0VZLCBidHJlZSAoaW50el9pZCkNCiAgICAibmZfaW50el9m azFfaWR4IiBidHJlZSAoaW50el9pZCkNCkZvcmVpZ24ta2V5IGNvbnN0cmFpbnRzOg0KICAgICJu Zl9pbnR6X2ZrMSIgRk9SRUlHTiBLRVkgKGludHpfaWQpIFJFRkVSRU5DRVMgaWRfZ2Vueih1cV9p ZCkgT04gREVMRVRFCkNBU0NBREUNCg0KDQpHZW5EYXRhREI9PiBcZCsgaWRfZ2VuejsNCiAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICBUYWJsZSAicHVibGljLmlkX2dlbnoiDQogQ29s dW1uIHwgIFR5cGUgIHwgQ29sbGF0aW9uIHwgTnVsbGFibGUgfCBEZWZhdWx0IHwgU3RvcmFnZSB8 IFN0YXRzIHRhcmdldCB8CkRlc2NyaXB0aW9uDQotLS0tLS0tLSstLS0tLS0tLSstLS0tLS0tLS0t LSstLS0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0t LS0tLQ0KICB1cV9pZCB8IGJpZ2ludCB8ICAgICAgICAgICB8IG5vdCBudWxsIHwgICAgICAgICB8 IHBsYWluICAgfCAgICAgICAgICAgICAKfA0KSW5kZXhlczoNCiAgICAiaWRfZ2Vuel9wayIgUFJJ TUFSWSBLRVksIGJ0cmVlICh1cV9pZCkNClJlZmVyZW5jZWQgYnk6DQogICAgVEFCTEUgIm5mX2lu dHoiIENPTlNUUkFJTlQgIm5mX2ludHpfZmsxIiBGT1JFSUdOIEtFWSAoaW50el9pZCkKUkVGRVJF TkNFUyBpZF9nZW56KHVxX2lkKSBPTiBERUxFVEUgQ0FTQ0FERQ0KDQoNCkdlbkRhdGFEQj0+IHNl bGVjdCBpbnR6X2lkIGZyb20gbmZfaW50eiB3aGVyZSBpbnR6X2lkIG5vdCBpbiAoc2VsZWN0IHVx X2lkCmZyb20gaWRfZ2Vueik7DQogIGludHpfaWQNCi0tLS0tLS0tLS0tDQogIDUwMDAwMDENCiAg NTAwMDAwMg0KICA1MDAwMDAzDQogIDUwMDAwMDQNCig0IHJvd3MpDQoNCg0KR2VuRGF0YURCPT4g cmVpbmRleCB0YWJsZSBuZl9pbnR6Ow0KUkVJTkRFWA0KR2VuRGF0YURCPT4gcmVpbmRleCB0YWJs ZSBpZF9nZW56Ow0KUkVJTkRFWA0KR2VuRGF0YURCPT4gc2VsZWN0IGludHpfaWQgZnJvbSBuZl9p bnR6IHdoZXJlIGludHpfaWQgbm90IGluIChzZWxlY3QgdXFfaWQKZnJvbSBpZF9nZW56KTsNCiAg aW50el9pZA0KLS0tLS0tLS0tLS0NCiAgNTAwMDAwMQ0KICA1MDAwMDAyDQogIDUwMDAwMDMNCiAg NTAwMDAwNA0KKDQgcm93cykNCg0KDQpHZW5EYXRhREI9Pg0KDQpGb3Igbm93LCB3ZSBoYXZlIHBy b2NlZWRlZCB3aXRoIHRoZSBkYXRhIG1pZ3JhdGlvbiBieSBhZGRpbmcgdGhlIG1pc3NpbmcKZW50 cmllcyB0byB0aGUgcGFyZW50IHRhYmxlLiBOZXZlcnRoZWxlc3MsIHBsZWFzZSBhZHZpc2UgaWYg dGhlcmUgaXMgc3RpbGwgYQpwb3NzaWJpbGl0eSBvZiBlbmNvdW50ZXJpbmcgb3JwaGFuZWQgcm93 cyBldmVuIHdoZW4gY29uc3RyYWludHMgYXJlIGluCnBsYWNlLiBJcyB0aGVyZSBhIHdheSB0byBw cmV2ZW50IHN1Y2ggb2NjdXJyZW5jZXMgaW4gdGhlIGZ1dHVyZT8KCg== --===============4243992334240496615==--