When a data set is created or changed, Firebird/InterBase® immediately checks the validity of the primary key. If the number already exists, or the field has been left blank, a key violation results, and the storage process is immediately cancelled.

Firebird/InterBase® immediately sends an error message referring to the violation of a unique or primary key constraint.