Issue Report: Unique Constraint Violation Error in PostgreSQL - Mailing list pgsql-bugs

Dear PostgreSQL Support Team,

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

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

Steps to Reproduce:

1. Created the table test_table:

   CREATE TABLE test_table (    id bigserial PRIMARY KEY,    name varchar
   );
   ALTER TABLE test_table OWNER TO postgres;
   

2. Inserted data into the table:

   INSERT INTO test_table (name) VALUES ('test1, no insert id');
   INSERT INTO test_table VALUES (2, 'test2, insert id');
   INSERT INTO test_table (name) VALUES ('test3, no insert id');
   

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

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

Environment Information:

• PostgreSQL Version:PostgreSQL 14.1 (Debian 14.1-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled 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 x86_64 x86_64 GNU/Linux

Reporting Method:
I am reporting this issue to seek assistance in resolving the unique constraint violation error. Please advise on the appropriate steps to address this issue.

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

Best regards,