Difference between revisions of "Unique constraint"

From wikieduonline
Jump to navigation Jump to search
Line 1: Line 1:
 +
{{lc}}
 +
 
  ERROR:  duplicate key value violates unique constraint "YOUR_TEXT_HERE"
 
  ERROR:  duplicate key value violates unique constraint "YOUR_TEXT_HERE"
 
  DETAIL: Key (id)=(XXXXXX) already exists
 
  DETAIL: Key (id)=(XXXXXX) already exists

Revision as of 15:33, 20 April 2023

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


Activities

See also

Advertising: