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 1sHKLj-0065b9-P4 for pgsql-bugs@arkaria.postgresql.org; Wed, 12 Jun 2024 09:33:01 +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 1sHKLh-00FXVJ-Dy for pgsql-bugs@arkaria.postgresql.org; Wed, 12 Jun 2024 09:32:58 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sHJlS-00F4p9-4N for pgsql-bugs@lists.postgresql.org; Wed, 12 Jun 2024 08:55:31 +0000 Received: from mail-tycjpn01olkn2012.outbound.protection.outlook.com ([40.92.99.12] helo=JPN01-TYC-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sHJlP-001Ez6-80 for pgsql-bugs@lists.postgresql.org; Wed, 12 Jun 2024 08:55:30 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=HONEtiWmopa4uuUmeR84ZhdvXPU1JPJFgbWmTwUHkurtlfbEG8+KwfPeXjwZze3bf5Pr2LRmk2WiaMHjMJ+q7/WI4twMYdoIPkVvXBzPsx5rN9qToN7677HxPuFwG7jn8Ljh7b65lLpF1pwKbvYWNUU1ovntciLgzBh9DhJhDu+crE0P9/chd30ldhYArMQgqB54vhEmQiAv3KCSSGw0N3xY/hTX7dYRPcejiqCvziDWG6sqSh4mWOdjx0F6RrtNjVWAuts6NNJ8+SbyOwxPmW0RVmcMCbN//+MdX1yr8SuMy5mtS5w0Y0i/c67QOSv+gt1LsHEFKLYw63Ayw6nxDg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=f8ZoPjBD8sKWGuV/e+sv9xRaJ7pNVwccOAEYR+q5bzg=; b=f2bSIIeUdRqf/iLF/snNOFZ6Zv1E7xAg7WDtG1UDaNTgyOiSiDsyyw3ghBjOzWvlcgw1jaaezhneGaPd0skgCF+0g8EjneqBHjH5UL3/5QPY/2knvhXDU6E39JiDgmLZu1I6KRrWvNDNyJEUTKz1tY1gmOsU3gpdvbIp3t7vrCdt5ubNVxU0PhHr+7NcOX7FbWFUgjm6auzfrHYiq30fEviSPu2XFsahl4Up7qcbjhDnmNovMt7+2+lHVIksjZaoR2uHy7qPvSkK9yIcV1Ixu8TYqujZeapeh3AqIEFvOCyaQgCEBFBwgXDtbGtRKmklTHRVBW+gBYkfPqxVPfBKiA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=outlook.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=f8ZoPjBD8sKWGuV/e+sv9xRaJ7pNVwccOAEYR+q5bzg=; b=VCZDhUJZBK+0Jq6Rsc3MEx4xkp7q1QaP0Qaub9qDvr1wLZGABB3ED/Tyu4+yp+02VxojPALHEjMkZpDA/XKAP32yzlDAjSES6P3ywsTH6DNwJ2TzhcXfBMgJ9+Nbr1hNLEU/08DWTp9VddzXY2+vCBfLeCerZXlMjus6qhWMYyMuYmn4p13Sc4TrJHyrSl+6wNzVt6ESpMSaQPf317Qgpl3p0YLFB4VN56jkRPXSaMTtttNuDxldSn4B9rIJx0oWweUlUSeWj9Madx3Wwr2iexbbOCnyPVTjzbDLNZf+kdYfUM7zUo79ffJxFuPu9CWWAqIe1fBvQSBn7nWlrTnbUw== Received: from TYCP286MB2292.JPNP286.PROD.OUTLOOK.COM (2603:1096:400:139::11) by TYYP286MB1785.JPNP286.PROD.OUTLOOK.COM (2603:1096:400:ff::14) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7677.20; Wed, 12 Jun 2024 08:55:22 +0000 Received: from TYCP286MB2292.JPNP286.PROD.OUTLOOK.COM ([fe80::95b7:a766:ae2c:b776]) by TYCP286MB2292.JPNP286.PROD.OUTLOOK.COM ([fe80::95b7:a766:ae2c:b776%7]) with mapi id 15.20.7633.037; Wed, 12 Jun 2024 08:55:22 +0000 Date: Wed, 12 Jun 2024 16:55:23 +0800 From: "sing_hijo@outlook.com" To: pgsql-bugs Subject: Issue Report: Unique Constraint Violation Error in PostgreSQL X-GUID: FD65C3E6-38A3-4883-8161-46D3D81013F1 X-Has-Attach: no X-Mailer: Foxmail 7.2.25.254[cn] Message-ID: Content-Type: multipart/alternative; boundary="----=_001_NextPart823601856847_=----" X-TMN: [fqjH58dB5aicasuGxjvqGuLqkSVTKTb8] X-ClientProxiedBy: TYWP286CA0008.JPNP286.PROD.OUTLOOK.COM (2603:1096:400:178::11) To TYCP286MB2292.JPNP286.PROD.OUTLOOK.COM (2603:1096:400:139::11) X-Microsoft-Original-Message-ID: <202406121655214926333@outlook.com> MIME-Version: 1.0 X-MS-Exchange-MessageSentRepresentingType: 1 X-MS-PublicTrafficType: Email X-MS-TrafficTypeDiagnostic: TYCP286MB2292:EE_|TYYP286MB1785:EE_ X-MS-Office365-Filtering-Correlation-Id: c3431beb-3567-4a8b-396b-08dc8abd6463 X-Microsoft-Antispam: BCL:0;ARA:14566002|461199020|440099020|3412199017; X-Microsoft-Antispam-Message-Info: 5AiRMpNTfd4sCFlMVUHpOz19WkHnLqnQpUPa4tKi5a/nflkIbrS3zmsnrMrmLPFICFx4WRKpXuB87qGl9mwNIJszX/UuEPuVt88p/hfTzPZHuUHuHTEqFZf9gs7tGQ4DxMSmBWHwMcCWDrZ7az4V0Gr3BPlxzx8tHTT/Pb0JqEgzZTuONG8LBwvF6mtAcr4DnWt2qo2TAhRZez/kKic8K2A7Y0/YhRuN3zVto9MIBFuUq0nZ0Nm7Q/mh6Rz3sbD7/ux/A6rTbw82Bnpq/YisicctiNqX+ffuIfaj+nInpzpx0SD3ZpQXkMb+7GNgqA0EbyPkckuJdI6PU6jtBmHPE2/cwL6r9FObIeu56Cy4dY1eqTikWj/hzHbGRTvzrq5A0r4nfn4+cx/ZnNH56138jzgaQcPmgkgLgvULhTzIfu/LYiOB6VUK0wxPs4AQtxXeQuvDpMwvkwuVHiTPl3R9CeaJKwKeWF4KhdXCZXu7PVMFrHyWsqS/6xQfWZcMfotQavE/ZQbg0URLqQ7E2kzWlrq3RT6D7RZDemtffYVjElEhlvNUd3fUFmOFI6eY9TO9 X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: =?us-ascii?Q?1mFUk47j39S51s/XmfgjuEqoftGY+YtEZS0zSEOjApTUoIxgRWLsoWO8wFEd?= =?us-ascii?Q?lhT8scE05sP5ipOzxtv2W03i2o0l8LbaP6oLlBKLdTrX0kaKXiNiyY7fTsUV?= =?us-ascii?Q?IMBJE1RdFzZPGPvOYqC8mdF8G8sANkU8jCpz9ViUYCJWslfdTrz3A96jZAPA?= =?us-ascii?Q?IfL5q7UsDNBSvc9QA0gqCvVig43AHIv1yi0S/EmHhHpf0lFeWN9M1PKeqM0O?= =?us-ascii?Q?W+Lj5T4Hr6jsNfIYTDuS4BVG5yPWIiUwmvWxKWXNvMr4tZIm/bytxSitysjF?= =?us-ascii?Q?6ih2WxPdhESX5wIqhk2AjZGqfHHQsEGA0PZsNfKExtDwU49zwbxSVhlu668a?= =?us-ascii?Q?5tE9q9oxTQC1lwg4UhNTVGBphGHDfg5GYs8HLs1dFsn9mU1l3V9b1PnLi1DK?= =?us-ascii?Q?D0sljOJRzlEPb6hCMyT8/AZ0A4oMsC5bJKv4E7q3JG8BrwqCcRqX1FbdggIm?= =?us-ascii?Q?KDe52c8qJQMtC/wIrwI3DTBmKVJt56yH3KmAAZ4y66M4ogZmxGJ8IUNAPxhS?= =?us-ascii?Q?7qZ78AQF2d3YKz8b19UjX/fMJYXpYxrAuTAKRs473+b+pIsPfRwqOV9OVUpK?= =?us-ascii?Q?oiHJrBG/1ZhSdLwzCMdvEQE3EGCWIWSqDfUvb+/gYB04UYMTh+YclhQz3PHT?= =?us-ascii?Q?+emi0AQ0jBqorHcWboqt2ttSUdU6J88+LXk5aK7FbzDdHUJNWdrzVjMZha9m?= =?us-ascii?Q?2dWidDqoSnQWUEKJZ+tCg5PCoSox43AYe82wdSGtjCHzm2gzjwTBSkVuyBxU?= =?us-ascii?Q?hsnP286pnsQ5m3YePXzWMkaHK/BGDLigx5cbMmPKmyQJrB3m/Cb7qY/yboKg?= =?us-ascii?Q?x+ViSp3Q7g9CNvC6g5yyfDQXTSELgmRzk0Ygr0scSTxwAdKAoy/yNOlddYJO?= =?us-ascii?Q?sTRi0Drxr/NGY58i9Q1GbL8W6Is61Tuk4WVOKchiw/ZRvTbBWrbl/aUjhKeR?= =?us-ascii?Q?8mn5STPCtFDqi/KEBA0IeUc+/0RPVjLT6vH0ODQF5j1J75Of2EMNgEFUEIDL?= =?us-ascii?Q?totGkDiedgQsBZWdKmr/RjjAv+VIuFZc7Q7eQESde/ivHbE9Q6QAQvaiCVrE?= =?us-ascii?Q?hSOhzRI6BCRyRzEZDkTKKmKY9UV09oTjDvycxUeIdtBMwUe/v2lAIGqoRDo6?= =?us-ascii?Q?4u6CHZ+j2jXhOBQrRuigYJPviEx7vxyk7afj2aMdQiop5yegpIijwC7YClTV?= =?us-ascii?Q?kefGiMkPyW11QjI5BW18o5mmuzTBlfOpvs0xsZv6ZhozwsPBO02/AqyrS+CC?= =?us-ascii?Q?A2kZRP300avrwgQpbXOJwPsHxxK7GYyilXTdXRLpag=3D=3D?= X-OriginatorOrg: outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: c3431beb-3567-4a8b-396b-08dc8abd6463 X-MS-Exchange-CrossTenant-AuthSource: TYCP286MB2292.JPNP286.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-OriginalArrivalTime: 12 Jun 2024 08:55:22.0096 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-CrossTenant-Id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYYP286MB1785 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_001_NextPart823601856847_=---- Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: base64 RGVhciBQb3N0Z3JlU1FMIFN1cHBvcnQgVGVhbSwNCkkgYW0gd3JpdGluZyB0byByZXBvcnQgYW4g aXNzdWUgSSBlbmNvdW50ZXJlZCB3aGlsZSB3b3JraW5nIHdpdGggdGhlIFBvc3RncmVTUUwgZGF0 YWJhc2UuIEJlbG93IGFyZSB0aGUgZGV0YWlscyBvZiB0aGUgcHJvYmxlbToNClByb2JsZW0gRGVz Y3JpcHRpb246DQpJIGVuY291bnRlcmVkIGEgdW5pcXVlIGNvbnN0cmFpbnQgdmlvbGF0aW9uIGVy cm9yIHdoZW4gYXR0ZW1wdGluZyB0byBpbnNlcnQgZGF0YSBpbnRvIGEgdGFibGUuDQpTdGVwcyB0 byBSZXByb2R1Y2U6DQpDcmVhdGVkIHRoZSB0YWJsZSB0ZXN0X3RhYmxlOkNSRUFURSBUQUJMRSB0 ZXN0X3RhYmxlICgKICAgIGlkIGJpZ3NlcmlhbCBQUklNQVJZIEtFWSwKICAgIG5hbWUgdmFyY2hh cgopOwpBTFRFUiBUQUJMRSB0ZXN0X3RhYmxlIE9XTkVSIFRPIHBvc3RncmVzOwoNCkluc2VydGVk IGRhdGEgaW50byB0aGUgdGFibGU6SU5TRVJUIElOVE8gdGVzdF90YWJsZSAobmFtZSkgVkFMVUVT ICgndGVzdDEsIG5vIGluc2VydCBpZCcpOwpJTlNFUlQgSU5UTyB0ZXN0X3RhYmxlIFZBTFVFUyAo MiwgJ3Rlc3QyLCBpbnNlcnQgaWQnKTsKSU5TRVJUIElOVE8gdGVzdF90YWJsZSAobmFtZSkgVkFM VUVTICgndGVzdDMsIG5vIGluc2VydCBpZCcpOwoNClJlc3VsdDoNCkVycm9yIG1lc3NhZ2U6IFsy MzUwNV0gRVJST1I6IGR1cGxpY2F0ZSBrZXkgdmFsdWUgdmlvbGF0ZXMgdW5pcXVlIGNvbnN0cmFp bnQgInRlc3RfdGFibGVfcGtleSIgRGV0YWlsOiBLZXkgKGlkKT0oMikgYWxyZWFkeSBleGlzdHMu DQpFeHBlY3RlZCBSZXN1bHQ6DQpJIGV4cGVjdGVkIHRoZSBkYXRhIHRvIGJlIGluc2VydGVkIHN1 Y2Nlc3NmdWxseSB3aXRob3V0IGVuY291bnRlcmluZyBhIHVuaXF1ZSBjb25zdHJhaW50IHZpb2xh dGlvbi4NCkVudmlyb25tZW50IEluZm9ybWF0aW9uOg0KUG9zdGdyZVNRTCBWZXJzaW9uOlBvc3Rn cmVTUUwgMTQuMSAoRGViaWFuIDE0LjEtMS5wZ2RnMTEwKzEpIG9uIHg4Nl82NC1wYy1saW51eC1n bnUsIGNvbXBpbGVkIGJ5IGdjYyAoRGViaWFuIDEwLjIuMS02KSAxMC4yLjEgMjAyMTAxMTAsIDY0 LWJpdA0KUGxhdGZvcm0gSW5mb3JtYXRpb246IFVidW50dS0yNC4wNCAgTGludXggc2luIDUuMTUu MTQ2LjEtbWljcm9zb2Z0LXN0YW5kYXJkLVdTTDIgIzEgU01QIFRodSBKYW4gMTEgMDQ6MDk6MDMg VVRDIDIwMjQgeDg2XzY0IHg4Nl82NCB4ODZfNjQgR05VL0xpbnV4DQpSZXBvcnRpbmcgTWV0aG9k Og0KSSBhbSByZXBvcnRpbmcgdGhpcyBpc3N1ZSB0byBzZWVrIGFzc2lzdGFuY2UgaW4gcmVzb2x2 aW5nIHRoZSB1bmlxdWUgY29uc3RyYWludCB2aW9sYXRpb24gZXJyb3IuIFBsZWFzZSBhZHZpc2Ug b24gdGhlIGFwcHJvcHJpYXRlIHN0ZXBzIHRvIGFkZHJlc3MgdGhpcyBpc3N1ZS4NClRoYW5rIHlv dSBmb3IgeW91ciBhdHRlbnRpb24gdG8gdGhpcyBtYXR0ZXIuIEkgbG9vayBmb3J3YXJkIHRvIHlv dXIgZ3VpZGFuY2Ugb24gcmVzb2x2aW5nIHRoaXMgaXNzdWUuDQpCZXN0IHJlZ2FyZHMsDQoNCg0K DQpzaW5nX2hpam9Ab3V0bG9vay5jb20NCg== ------=_001_NextPart823601856847_=---- Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable =0A=

Dear PostgreSQL Support Team,=

I am writing to report an issue I encounter= ed while working with the PostgreSQL database. Below are the details of the= problem:

Problem Description:
I encounter= ed a unique constraint violation error when attempting to insert data into = a table.

Steps to Reproduce:

    Created the table test_table:
    CREATE TABLE test_table (=
=0A=
    id bigserial PRIMARY KEY,=0A=
    name var=
char=0A=
);=0A=
ALTER TABLE=
 test_table OWNER TO postgres;=0A=
  1. Inserted data into the = table:
    <=
/span>INSERT INTO te=
st_table (name) VALUES ('test1, no insert id');=0A=
INSERT INTO=
 test_table VALUES (2, 'test2, insert id');=0A=
INSERT INTO=
 test_table (name) VALUES ('test3, no insert id');=0A=

Result:
Error message:= [23505] ERROR: duplicate key value violates unique constraint "test_t= able_pkey" Detail: Key (id)=3D(2) already exists.

Expected Result:
I expected the data to be inserted successful= ly without encountering a unique constraint violation.

Environment Information:

  • PostgreSQL Ve= rsion:PostgreSQL 14.1 (Debian 14.1-1.pgdg110+1) on x86_64-pc-linux-gnu, com= piled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
  • Platform Information: Ubuntu-24.04  Linux sin 5.15= .146.1-microsoft-standard-WSL2 #1 SMP Thu Jan 11 04:09:03 UTC 2024 x86_64 x= 86_64 x86_64 GNU/Linux

Reporting Method:
I am reporting this issue to seek assistance in resolving the unique c= onstraint violation error. Please advise on the appropriate steps to addres= s this issue.

Thank you for your attention t= o this matter. I look forward to your guidance on resolving this issue.

=

Best regards,

=0A=

=0A=
sing_hijo@outlook.com
=0A= = ------=_001_NextPart823601856847_=------