Unique constraint

ERROR:  duplicate key value violates unique constraint "YOUR_TEXT_HERE"
DETAIL: Key (id)=(XXXXXX) already exists

Sonarqube

### Error updating database.  Cause: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "live_measures_component"

Related

• ALTER TABLE tablename ADD CONSTRAINT constraintname UNIQUE (columns);
• duplicated keys
• Foreign Keys
• Locking

Activities

• Read https://aws.amazon.com/blogs/database/hidden-dangers-of-duplicate-key-violations-in-postgresql-and-how-to-avoid-them/

See also

• Locking, Index locking
• SQL, NewSQL, RDMS: GraphQL (2015), SQLite, select, insert, select count, Distributed SQL, TablePlus, Cache hit ratio, pg_stat_user_tables, EXPLAIN, Index (PostgreSQL), DDL, SQL/MED, Group by, List users, SQL Injection, SQLAlchemy, CREATE USER, CREATE ROLE, EXPLAIN, ALTER DATABASE, REVOKE, NOLOCK, NOWAIT, EXISTS, Unique constraint, .sql