SQL

postgresql resolv duplicate value violates unique constraint

SELECT setval(pg_get_serial_sequence('users', 'id'), coalesce(max(id)+1, 1), false) FROM users;

postgres duplicate key value violates unique constraint already exists

SELECT setval('the_primary_key_sequence', (SELECT MAX(the_primary_key) FROM the_table)+1);

duplicate key value violates unique constraint in postgresql

SELECT setval('tableName_id_seq', max(id)) FROM gst_codes;

IntegrityError at duplicate key value violates unique constraint DETAIL: Key id already exists.

# Reset the counter of a table named yourTable to start at id # 1453
ALTER SEQUENCE yourTable_id_seq RESTART WITH 1453

psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint ""

INSERT INTO blog 
  VALUES (1,'AWS Blog1') 
  ON CONFLICT DO NOTHING;
INSERT 0 0