Difference between revisions of "Unique constraint"
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 9: | Line 9: | ||
== Related == | == Related == | ||
| − | + | * [[ALTER TABLE]] tablename ADD [[CONSTRAINT]] constraintname UNIQUE (columns); | |
| − | + | * [[duplicated keys]] | |
| − | + | * [[Foreign Keys]] | |
| + | * [[Locking]] | ||
== Activities == | == Activities == | ||
| Line 17: | Line 18: | ||
== See also == | == See also == | ||
| + | * {{Locking}} | ||
* {{SQL}} | * {{SQL}} | ||
[[Category:SQL]] | [[Category:SQL]] | ||
Latest revision as of 10:43, 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[edit]
- ALTER TABLE tablename ADD CONSTRAINT constraintname UNIQUE (columns);
- duplicated keys
- Foreign Keys
- Locking
Activities[edit]
See also[edit]
- Locking, Index locking
- SQL, NewSQL: 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
Advertising:
