Re: Issue Report: Unique Constraint Violation Error in PostgreSQL

Hi Sing_hijo,

Could you try this

SELECT setval(pg_get_serial_sequence('test_table', 'id'), (SELECT MAX(id)
FROM test_table));

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

SELECT * FROM test_table;
 setval
--------

(1 row)

INSERT 0 1
 id |        name
----+---------------------
  3 | test3, no insert id
(1 row)


Regards,
Ikram


On Wed, Jun 12, 2024 at 2:33 PM sing_hijo@outlook.com <sing_hijo@outlook.com>
wrote:

> 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,
>
> ------------------------------
> sing_hijo@outlook.com
>


-- 
Muhammad Ikram