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 1ooUIT-0003HR-Il for pgsql-admin@arkaria.postgresql.org; Fri, 28 Oct 2022 18:41:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ooUIS-0006KC-1P for pgsql-admin@arkaria.postgresql.org; Fri, 28 Oct 2022 18:41:36 +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 1ooUIR-0006K2-Ms for pgsql-admin@lists.postgresql.org; Fri, 28 Oct 2022 18:41:35 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ooUIN-0000G0-QB for pgsql-admin@lists.postgresql.org; Fri, 28 Oct 2022 18:41:33 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 3C40F380FF6; Fri, 28 Oct 2022 20:41:30 +0200 (CEST) Received: from rs.plausibolo.de ([IPv6:::1]) by localhost (h2367442.stratoserver.net [IPv6:::1]) (amavisd-new, port 10024) with ESMTP id zqdfYFGirawi; Fri, 28 Oct 2022 20:41:30 +0200 (CEST) Received: from [192.168.0.178] (ip-109-40-240-24.web.vodafone.de [109.40.240.24]) by rs.plausibolo.de (Postfix) with ESMTPSA id C6A9D380273; Fri, 28 Oct 2022 20:41:29 +0200 (CEST) Message-ID: <74e777cb-c332-3db7-7c4a-784d408227d6@jakobs.com> Date: Fri, 28 Oct 2022 20:41:29 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.0 Subject: Re: Duplicate data even with primary keys enabled To: pgsql-admin@lists.postgresql.org References: <59B1180A-4A4B-4A1A-B50A-C9D9B41AA67D@gmail.com> From: Holger Jakobs In-Reply-To: <59B1180A-4A4B-4A1A-B50A-C9D9B41AA67D@gmail.com> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------zgxyvHeUmX69LtpsvBDz0hev" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------zgxyvHeUmX69LtpsvBDz0hev Content-Type: multipart/mixed; boundary="------------zjBdLv02edeqDjVdtCjjsKEP"; protected-headers="v1" From: Holger Jakobs To: pgsql-admin@lists.postgresql.org Message-ID: <74e777cb-c332-3db7-7c4a-784d408227d6@jakobs.com> Subject: Re: Duplicate data even with primary keys enabled References: <59B1180A-4A4B-4A1A-B50A-C9D9B41AA67D@gmail.com> In-Reply-To: <59B1180A-4A4B-4A1A-B50A-C9D9B41AA67D@gmail.com> --------------zjBdLv02edeqDjVdtCjjsKEP Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 DQpBbSAyOC4xMC4yMiB1bSAyMDoyNyBzY2hyaWViIFRlamEgSmFra2lkaToNCj4gSGkgWUlM RElSSU0sDQo+DQo+IFRoYW5rcyBmb3IgeW91ciByZXNwb25zZS4NCj4NCj4gV2UgaGF2ZSBh IGNvbXBvc2l0ZSBwcmltYXJ5IGtleSBvbiAzY29sdW1ucy4gV2UgYXJlIG5vdGljaW5nIG11 bHRpcGxlIA0KPiByb3dzIHdpdGggc2FtZSB2YWx1ZXMgaW4gdGhlIDNwayBjb2x1bW5zIHdo aWNoIHNob3VsZCBub3QgaGFwcGVuIGFzIA0KPiBwcmltYXJ5IGNvbnN0cmFpbnQgaXMgZGVm aW5lZCBvbiB0aGVtLg0KPiBBbHNvLCBub25lIG9mIHRoZSBjb2x1bW5zIGFyZSBudWxsLg0K Pg0KPiBSZWdhcmRzLA0KPiBUZWphLiBKLg0KPg0KVW5sZXNzIHlvdSBkb24ndCBwb3N0IHlv dXIgQ1JFQVRFIFRBQkxFIGNvbW1hbmQgcGx1cyBzb21lIElOU0VSVCBjb21tYW5kIA0Kd2hp Y2ggbGVhZCB0byB0aGUgZGVzY3JpYmVkIGJlaGF2aW9yLCB3ZSB3b24ndCBiZSBhYmxlIHRv IHRyYWNrIHRoZSBwcm9ibGVtLg0KDQoNCi0tIA0KSG9sZ2VyIEpha29icywgQmVyZ2lzY2gg R2xhZGJhY2gsIFRlbC4gKzQ5LTE3OC05NzU5MDEyDQoNCg== --------------zjBdLv02edeqDjVdtCjjsKEP-- --------------zgxyvHeUmX69LtpsvBDz0hev Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCY1wiWQUDAAAAAAAKCRCKV5yTsxlhugQ3 AJ0UgWg1/m2M+HWEwFk6t+q+8u5PhACfeJGy/mYPxeF4XHY/9/q9Nt1hW4o= =So6J -----END PGP SIGNATURE----- --------------zgxyvHeUmX69LtpsvBDz0hev--