Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qD8up-0002SQ-TL for pgsql-bugs@arkaria.postgresql.org; Sat, 24 Jun 2023 19:27:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qD8uo-0008Dx-FA for pgsql-bugs@arkaria.postgresql.org; Sat, 24 Jun 2023 19:27:22 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qCwLb-0006Mc-7t for pgsql-bugs@lists.postgresql.org; Sat, 24 Jun 2023 06:02:11 +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.94.2) (envelope-from ) id 1qCwLU-000ACX-In for pgsql-bugs@lists.postgresql.org; Sat, 24 Jun 2023 06:02:10 +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=8dFAb1yqC9oaj1vicnU9CjMuJfknQbpwVRBlMcQX95A=; b=0rm+RzoWXGcivxiTZSienOWt+z wCPl6D+0wk68mFDqCIbZMfT0M9X2+3F8llVsMk6xc/OB5f1tDaoXTvdWgOGC6BtrfE7jWn+iGCINb S5aZv2QTRjbD829/4NXeIqqagapUio2lK+whnpLMtg0M5rynBR1zF4I2T2zeszrnmTndm3asSr4LI ScMhc5wr3I6oNZo1tWzBqFwh81/ftlzfJZ/JP3yrSiiZIoeRYJVlGiw0Iwd4GdEYf2Igf+6xXrUWb TOWcCj2x4pEUlKc3CPqUwW+ULN4wrkpWbNckZLAP2k7RoMqC3iR1C/qWQUMFhmDnA58W3S3yGK7bX clF9Jvmw==; 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 1qCwLT-0000La-G1 for pgsql-bugs@lists.postgresql.org; Sat, 24 Jun 2023 06:02:03 +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 1qCwLR-000SOW-Ui for pgsql-bugs@lists.postgresql.org; Sat, 24 Jun 2023 06:02:02 +0000 Content-Type: multipart/mixed; boundary="===============7994910350305877977==" MIME-Version: 1.0 Subject: BUG #17993: FK issue on logical replication table To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: salmanbasmechi@gmail.com Reply-To: salmanbasmechi@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sat, 24 Jun 2023 06:01:25 +0000 Message-ID: <17993-2c0731369915b8ec@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 --===============7994910350305877977== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzk5MwpMb2dnZWQgYnk6ICAgICAgICAgIFNhbG1hbiBCYXNtZWNoaQpF bWFpbCBhZGRyZXNzOiAgICAgIHNhbG1hbmJhc21lY2hpQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZl cnNpb246IDE1LjMKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjIuMDQKRGVzY3JpcHRpb246 ICAgICAgICAKCkRlYXIgUG9zdGdyZXMgZGV2ZWxvcGVyLA0KSSBhbSBTYWxtYW4gQmFzbWVjaGkg ZnJvbSBJcmFuLiBJIGZvdW5kIGEgYnVnIGluIGxvZ2ljYWwgcmVwbGljYXRpb24KYmVoYXZpb3Iu IGl0IHNlZW1zIGZvcmVpZ24ga2V5IGNvbnN0cmFpbnQgZG9lcyBub3QgYXBwbHkgaW4gbG9naWNh bApyZXBsaWNhdGlvbiBtZWNoYW5pc20uDQpCZWxvdyBzY3JpcHRzIGlzIGEgc2FtcGxlIHlvdSBj YW4gcnVuIGluIGEgc2luZ2xlIG1hY2hpbmUgYW5kIHNlZSB0aGUgd3JvbmcKYmVoYXZpb3IuDQoN CnB1YmxpY2F0aW9uIHNpZGU6DQpjcmVhdGUgZGF0YWJhc2UgcHViX2Jhc21lY2hpOw0KY3JlYXRl IHRhYmxlIG1hdGVyaWFsIChpZCBiaWdzZXJpYWwgcHJpbWFyeSBrZXksIG5hbWUgdGV4dCk7DQpj cmVhdGUgcHVibGljYXRpb24gcHViIGZvciB0YWJsZSBtYXRlcmlhbDsNCmNyZWF0ZSBwZ19jcmVh dGVfbG9naWNhbF9yZXBsaWNhdGlvbl9zbG90KCJzbG90XzEiLCAicGdvdXRwdXQiKTsNCmluc2Vy dCBpbnRvIG1hdGVyaWFsIChuYW1lKSB2YWx1ZXMgKCJtb2JpbGUiKTsgLy8gd2UgZXhwZWN0ZWQg bWF0ZXJpYWwgd2l0aAppZCA9IDEgY3JlYXRlIGFmdGVyIHJ1biB0aGlzIGxpbmUNCg0Kc3Vic2Ny aXB0aW9uIHNpZGU6DQpjcmVhdGUgZGF0YWJhc2Ugc3ViX2Jhc21lY2hpOw0KY3JlYXRlIHRhYmxl IG1hdGVyaWFsIChpZCBiaWdzZXJpYWwgcHJpbWFyeSBrZXksIG5hbWUgdGV4dCk7DQpjcmVhdGUg dGFibGUgcHJvZHVjdCAoaWQgYmlnc2VyaWFsIHByaW1hcnkga2V5LCBtYXRlcmlhbF9pZCBiaWdp bnQKcmVmZXJlbmNlcyBtYXRlcmlhbCwgbmFtZSB0ZXh0KTsNCmNyZWF0ZSBzdWJzY3JpcHRpb24g c3ViDQpjb25uZWN0aW9uICdob3N0PWxvY2FsaG9zdCBwb3J0PTU0MzIgZGJuYW1lPXB1Yl9iYXNt ZWNoaSB1c2VyPXBvc3RncmVzCnBhc3N3b3JkPWFkbWluJw0KcHVibGljYXRpb24gcHViDQp3aXRo IChzbG90X25hbWU9c2xvdF8xLCBjcmVhdGVfc2xvdD1mYWxzZSk7DQoNCmFmdGVyIHJlcGxpY2F0 ZSBtYXRlcmlhbCAnbW9iaWxlJyBpbnRvIHN1Yl9iYXNtZWNoaSBkYXRhYmFzZToNCi8vIHdlIGV4 cGVjdGVkIG1hdGVyaWFsICdtb2JpbGUnIHdpdGggaWQgPSAxIGV4aXN0IGFuZCB3ZSBjYW4gcmVm ZXJlbmNlCnRoYXQNCmluc2VydCBpbnRvIHByb2R1Y3QgKG1hdGVyaWFsX2lkLCBuYW1lKSB2YWx1 ZXMgKDEsICdwcm9kdWN0X21vYmlsZScpDQovLyB3ZSBleHBlY3RlZCBoYXZlIG9uZSBwcm9kdWN0 IGluIHRhYmxlIHByb2R1Y3Qgd2l0aCBuYW1lID0KJ3Byb2R1Y3RfbW9iaWxlJyB0aGF0IHJlZmVy ZW5jZSB0byBtYXRlcmlhbCB3aXRoIGlkID0gMSBhbmQgbmFtZSA9Cidtb2JpbGUnDQoNCm5vdyBk ZWxldGUgbWF0ZXJpYWwgaW4gcHViX2Jhc21lY2hpIGRhdGFiYXNlOg0KZGVsZXRlIGZyb20gbWF0 ZXJpYWwgd2hlcmUgaWQgPSAxOw0KDQpydW4gc2VsZWN0IHF1ZXJ5IGluIHN1Yl9iYXNtZWNoaSBk YXRhYmFzZToNCnNlbGVjdCAqIGZyb20gbWF0ZXJpYWw7DQovLyB1bmV4cGVjdGVkIHJlc3VsdC4g bWF0ZXJpYWwgd2l0aCBpZCA9IDEgaGFzIGJlZW4gZGVsZXRlZCBmcm9tCnN1Yl9iYXNtZWNoaSBh bmQgcHJvZHVjdCAncHJvZHVjdF9tb2JpbGUnIGV4aXN0cyBhbmQgcmVmZXJlbmNlIHRvIG1hdGVy aWFsCndpdGggaWQgPSAxLiBidXQgbWF0ZXJpYWwgZG9lcyBub3QgZXhpc3QhDQpzZWxlY3QgKiBm cm9tIHByb2R1Y3Q7DQovLyB3ZSBzZWUgb25lIHJlY29yZCBpbiBwcm9kdWN0IHRoYXQgaW5zZXJ0 ZWQgYmVmb3JlIHRoYXQgcmVmZXJlbmNlIHRvIG51bGwKcG9pbnQgaW4gbWF0ZXJpYWwgdGFibGUN Cg0KRmluYWxseSwgaXQgc2VlbXMgRksgY29uc3RyYWludCBkb2VzIG5vdCBhcHBseSBpbiByZXBs aWNhdGlvbiBhbmQgZGVsZXRlCnNpZ25hbCBmcm9tIHB1Ymxpc2hlciBjYW4gcmVtb3ZlIGFueSBy ZWZlcmVuY2VkIGRhdGEgaW4gc3Vic2NyaWJlci4NCkluIHlvdXIgZG9jcyB0aGVyZSBpcyBub3Qg YW55IGxpbmUgdGhhdCBub3RpY2UgdGhpcyBiZWhhdmlvciwgYW5kIGlmIGl0IGlzCm5vcm1hbCwg cGxlYXNlIHVwZGF0ZSB5b3VyIGRvY3MgYW5kIG5vdGlmeSBtZSBieSBlbWFpbC4NCg0KVGhhbmsg eW91LA0KU2FsbWFuIEJhc21lY2hpLA0KU2VuaW9yIFNvZnR3YXJlIEVuZ2luZWVyIEBzeXN0ZW1n cm91cC5uZXQNCg0Kc2FsbWFuYmFzbWVjaGlAZ21haWwuY29tDQorOTg5MTI5MzM1NjA3Cgo= --===============7994910350305877977==--