coder
diff --git a/‎coderd/apikey.go
Lines changed: 1 addition & 1 deletion b/‎coderd/apikey.go
Lines changed: 1 addition & 1 deletion
diff --git a/‎coderd/database/errors.go
Lines changed: 22 additions & 0 deletions b/‎coderd/database/errors.go
Lines changed: 22 additions & 0 deletions
diff --git a/‎coderd/database/foreign_key_constraint.go
Lines changed: 49 additions & 0 deletions b/‎coderd/database/foreign_key_constraint.go
Lines changed: 49 additions & 0 deletions
diff --git a/‎coderd/database/unique_constraint.go
Lines changed: 2 additions & 2 deletions b/‎coderd/database/unique_constraint.go
Lines changed: 2 additions & 2 deletions
@@ -91,7 +91,7 @@ func (api *API) postToken(rw http.ResponseWriter, r *http.Request) {
 		TokenName:        tokenName,
 	})
 	if err != nil {
-		if database.IsUniqueViolation(err, database.UniqueIndexApiKeyName) {
+		if database.IsUniqueViolation(err, database.UniqueIndexAPIKeyName) {
 			httpapi.Write(ctx, rw, http.StatusConflict, codersdk.Response{
 				Message: fmt.Sprintf("A token with name %q already exists.", tokenName),
 				Validations: []codersdk.ValidationError{{
 
@@ -37,6 +37,28 @@ func IsUniqueViolation(err error, uniqueConstraints ...UniqueConstraint) bool {
 	return false
 }
 
+// IsForeignKeyViolation checks if the error is due to a foreign key violation.
+// If one or more specific foreign key constraints are given as arguments,
+// the error must be caused by one of them. If no constraints are given,
+// this function returns true for any foreign key violation.
+func IsForeignKeyViolation(err error, foreignKeyConstraints ...ForeignKeyConstraint) bool {
+	var pqErr *pq.Error
+	if errors.As(err, &pqErr) {
+		if pqErr.Code.Name() == "foreign_key_violation" {
+			if len(foreignKeyConstraints) == 0 {
+				return true
+			}
+			for _, fc := range foreignKeyConstraints {
+				if pqErr.Constraint == string(fc) {
+					return true
+				}
+			}
+		}
+	}
+
+	return false
+}
+
 // IsQueryCanceledError checks if the error is due to a query being canceled.
 func IsQueryCanceledError(err error) bool {
 	var pqErr *pq.Error