Integrity constraint violations

Integrity constraint violations occur when an insert, update, or delete statement violates a primary key, foreign key, check, or unique constraint or a unique index.

Table 6-4: Integrity constraint violations

Message

Value

Description

Attempt to insert duplicate key row in object object_name with unique index index_name.

23000

Occurs when a duplicate row is inserted into a table that has a unique constraint or index.

Check constraint violation occurred, dbname = database_name, table name = table_name, constraint name = constraint_name.

23000

Occurs when an update or delete would violate a check constraint on a column.

Dependent foreign key constraint violation in a referential integrity constraint. dbname = database_name, table name = table_name, constraint name = constraint_name.

23000

Occurs when an update or delete on a primary key table would violate a foreign key constraint.

Foreign key constraint violation occurred, dbname = database_name, table name = table_name, constraint name = constraint_name.

23000

Occurs when an insert or update on a foreign key table is performed without a matching value in the primary key table.