How to fix an error when adding a record after importing to the database?

Question

PostgreSQL

Made import in the table. Imported more than 10 thousand records
Now, when inserting a new record into the table, an error occurs:
postgresql duplicate key value violates unique constraint
i.e. it does not create a new index chtoli ....
through PhpPgAdmin updated the index (rebuild the index) also does not help if the table is cleared that records are normally added.
Help me please

Answer 1

You are trying to insert a record that already exists in the table. The problem is not in the index, but in the restriction on the uniqueness of the record. Check the unique constraint on your table.

Answer 2

Problem with sequence, dig in this direction

Answer 3

ALTER SEQUENCE имя RESTART WITH значение_перезапуска;

You can view the current values ​​in sequence using SELECT