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(at)outlook(dot)com <sing_hijo(at)outlook(dot)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(at)outlook(dot)com
>

--
Muhammad Ikram