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 1mLOf5-0005ES-U1 for pgsql-bugs@arkaria.postgresql.org; Wed, 01 Sep 2021 11:44:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mLOf2-0003Vo-97 for pgsql-bugs@arkaria.postgresql.org; Wed, 01 Sep 2021 11:44:08 +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 1mLMRc-0006j7-IB for pgsql-bugs@lists.postgresql.org; Wed, 01 Sep 2021 09:22:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mLMRa-00088M-J5 for pgsql-bugs@lists.postgresql.org; Wed, 01 Sep 2021 09:22:08 +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=q9VXqo9jIVV9qzc9YKqRhUaGrutUwPnqhn5p6Favbm8=; b=0tjdSNKNfdif6XvNQIR4tiExes TeXcc68Z3/x7buXz/uKCQTaU6s3AT9R1vGHh5UEqtE/9wig045kZOqZmIOTvoRA1n3FxF8TTuTlSA tINFUSd5dtGm7DdxsypIRsmyqdy7+dbUxM2s3SMz7tw9YbVGRr3CI6kNxVYbcrmoWaOg+yHODASqG 6CxgToFWVGueH228gc5QhMFa+8/EqvbQXMN0b9cg4WgEpZeUkA7ePMCM8dK4ZiJLn9coXvBuNOILs nD5Ycui+YZNUwjMKTDThy7HRl0jzY6d+3e/DaLekxESaERt72qs1LYb7B4t+MKbM2G4yX0WBnFyhm nra7iMSQ==; 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 1mLMRZ-0006DZ-9e for pgsql-bugs@lists.postgresql.org; Wed, 01 Sep 2021 09:22:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mLMRW-0002ov-GV for pgsql-bugs@lists.postgresql.org; Wed, 01 Sep 2021 09:22:02 +0000 Content-Type: multipart/mixed; boundary="===============8376507389386805665==" MIME-Version: 1.0 Subject: BUG #17173: Primary Key ignored resulting in duplicate values To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: kdhanjee@gmail.com Reply-To: kdhanjee@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 01 Sep 2021 09:21:08 +0000 Message-ID: <17173-d0151264e4a69eb5@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 --===============8376507389386805665== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzE3MwpMb2dnZWQgYnk6ICAgICAgICAgIEtldGFuIERoYW5qZWUKRW1h aWwgYWRkcmVzczogICAgICBrZGhhbmplZUBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAx MS45Ck9wZXJhdGluZyBzeXN0ZW06ICAgQ2VudE9TIExpbnV4IDcKRGVzY3JpcHRpb246ICAgICAg ICAKCkRlYXIgU2lyL01hZGFtLA0KDQpXZSBoYXZlIGZvdW5kIGlzc3VlcyBvbiBvdXIgZGF0YWJh c2UgdGFibGVzIHdpdGggZHVwbGljYXRlIHZhbHVlcyBmb3IgdGFibGVzCmRlZmluZWQgd2l0aCBw cmltYXJ5IGtleXMuDQoNCkJlbG93IHBsZWFzZSBmaW5kIG91dHB1dCBmcm9tIG9uZSBvZiBvdXIg dGFibGVzIHdpdGggZHVwbGljYXRlIHZhbHVlcyBvbiB0aGUKcHJpbWFyeSBrZXk6DQoNClRhYmxl IERETDoNCg0KQ1JFQVRFIFRBQkxFIGNvbXBvbmVudC5wcmljZXVwZGF0ZQ0KKA0KICAgIGlkIGJp Z2ludCBOT1QgTlVMTCBHRU5FUkFURUQgQUxXQVlTIEFTIElERU5USVRZICggSU5DUkVNRU5UIDEg U1RBUlQgMQpNSU5WQUxVRSAxIE1BWFZBTFVFIDkyMjMzNzIwMzY4NTQ3NzU4MDcgQ0FDSEUgMSAp LA0KICAgIHJlZmVyZW5jZSBjaGFyYWN0ZXIgdmFyeWluZyg1MCkgQ09MTEFURSBwZ19jYXRhbG9n LiJkZWZhdWx0IiwNCiAgICBlZmZlY3RpdmVkYXRlIHRpbWVzdGFtcCg2KSB3aXRob3V0IHRpbWUg em9uZSwNCiAgICAidGltZXN0YW1wIiB0aW1lc3RhbXAoNikgd2l0aG91dCB0aW1lIHpvbmUsDQog ICAgcHJpY2V1cGRhdGVzdGF0dXMgY2hhcmFjdGVyIHZhcnlpbmcoNTApIENPTExBVEUgcGdfY2F0 YWxvZy4iZGVmYXVsdCIsDQogICAgbW9kaWZpZWRkYXRlIHRpbWVzdGFtcCg2KSB3aXRob3V0IHRp bWUgem9uZSwNCiAgICBDT05TVFJBSU5UIHByaWNldXBkYXRlX3BrZXkgUFJJTUFSWSBLRVkgKGlk KQ0KICAgICAgICBVU0lORyBJTkRFWCBUQUJMRVNQQUNFIHBnd2xpY3NkYg0KKQ0KV0lUSCAoDQog ICAgT0lEUyA9IEZBTFNFDQopDQpUQUJMRVNQQUNFIHBnd2xpY3NkYjsNCg0KLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NClNlbGVjdCBvdXRwdXQ6DQoNCnNlbGVj dCAqIGZyb20gY29tcG9uZW50LnByaWNldXBkYXRlIHdoZXJlIGlkPTMwMDEyNzk7DQoNCmlkICAg ICAgICAgICAgICAgICB8ICAgICByZWZlcmVuY2UgICAgICAgICAgIHwgICAgICAgZWZmZWN0aXZl ZGF0ZSAgICAgICAgICAKICAgICAgICB8ICB0aW1lc3RhbXAgICAgICAgICAgICAgICAgICAgICAg ICAgICB8ICAgIHByaWNldXBkYXRlc3RhdHVzICAgICAgCnwgbW9kaWZpZWRkYXRlDQotLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t DQozMDAxMjc5ICAgICAgICAxMjUwODEyNjczNzkzICAgICAgMjAyMS0wMy0xOCAgMDA6MDA6MDAg ICAgICAgICAgICAgICAKMjAyMS0wNC0wNiAgMTM6MTk6MTQuOTk3ICAgICBGYWlsZWQgICAgICAg ICAgICAgICAgICAgICAgICAgICAgMjAyMS0wNS0yMyAKMTI6MTY6NDkuNTAzDQozMDAxMjc5ICAg ICAgICAxMjUwODEyNjczNzkzICAgICAgMjAyMS0wMy0xOCAgMDA6MDA6MDAgICAgICAgICAgICAg ICAKMjAyMS0wNC0wNiAgMTM6MTk6MTQuOTk3ICAgICBGYWlsZWQgICAgICAgICAgICAgICAgICAg ICAgICAgICAgMjAyMS0wNS0yMyAKMTI6NDU6MDkuMjA2DQoNCldlIGhhdmUgb3RoZXIgdGFibGVz IHRoYXQgYWxzbyBoYXZlIGR1cGxpY2F0ZXMgZm9yIHByaW1hcnkga2V5Lg0KDQpDb3VsZCB5b3Ug cGxlYXNlIHByb3ZpZGUgZmVlZGJhY2sgd2l0aCByZWdhcmRzIHRvIG15IHF1ZXJ5Lg0KDQpUaGFu a3MNCktldGFuCgo= --===============8376507389386805665==--