Cause:org.postgresql.util.PSQLException:ERROR:duplicate key value violates UNIQUE constraint "Sams_sys_area_pkey"

Cause of the error:

I have redefined a self-increment table ("ID serial Primark key") in the SQL file of the table, but there is an INSERT statement in the SQL file that initializes the data, which is the ID self-increment field, not starting from 1.

When you add data, you'll get a question in the title.

Workaround:

After creating the table, execute the following sentence

Select Setval (' Sams_sys_area_id_seq ', (SELECT MAX (ID) from "Sams_sys_area") +1) "Settings"

SELECT nextval (' sams_sys_area_id_seq ':: Regclass) can be modified to see if the modification was successful

　　

Cause:org.postgresql.util.PSQLException:ERROR:duplicate key value violates UNIQUE constraint "Sams_sys_area_pkey"