SpringbootでInsertができない？ ERROR: duplicate key value violates unique constraint

org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "users_pkey"
Detail: Key (id)=(1) already exists.

DB初期投入時に連番型のIDに手動でデータを入れてしまったことが原因。

❌

insert.py

SQL='''
INSERT INTO users
(id, "password", username)
VALUES(1, '$2a$10$lzGogDHmrBAGt2vDX93mEee1GmGOPIk4g1TmG5xinWOVuk6GFE4ra', 'admin');
    '''

idの生成はPostgresSQLに任せないとおかしくなるので注意。

✅

insert.py

SQL='''
INSERT INTO users
("password", username)
VALUES('$2a$10$lzGogDHmrBAGt2vDX93mEee1GmGOPIk4g1TmG5xinWOVuk6GFE4ra', 'admin');
    '''

ちなみにエンティティの定義は至って普通

User.java

@Entity
@Table(name = "users",
        uniqueConstraints = {
                @UniqueConstraint(columnNames = "username")
        })
public class User implements Serializable {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;