Difference between revisions of "Unique constraint"
Jump to navigation
Jump to search
| Line 11: | Line 11: | ||
[[ALTER TABLE]] tablename ADD [[CONSTRAINT]] constraintname UNIQUE (columns); | [[ALTER TABLE]] tablename ADD [[CONSTRAINT]] constraintname UNIQUE (columns); | ||
[[duplicated keys]] | [[duplicated keys]] | ||
| + | [[Foreign Keys]] | ||
== Activities == | == Activities == | ||
Revision as of 07:44, 9 May 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
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:
