Difference between revisions of "Unique constraint"
Jump to navigation
Jump to search
| Line 9: | Line 9: | ||
== Related == | == Related == | ||
| − | + | * [[ALTER TABLE]] tablename ADD [[CONSTRAINT]] constraintname UNIQUE (columns); | |
| − | + | * [[duplicated keys]] | |
| − | + | * [[Foreign Keys]] | |
| + | * [[Locking]] | ||
== Activities == | == Activities == | ||
Revision as of 10:37, 11 July 2023
ERROR: duplicate key value violates unique constraint "YOUR_TEXT_HERE" DETAIL: Key (id)=(XXXXXX) already exists
### 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
See also
- 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
Advertising:
