Referential Integrity Load Violation

Vertica checks for constraint violations during query execution. It checks for violations during load operations only if you enable primary or unique key enforcement. In this case, Vertica checks for referential integrity constraint violations when loading data.

If Vertica detects a referential integrity constraint violation, the load rolls back and Vertica returns an error.