User Guide > User Guide > Analytics Engine and Ingres > Incompatibilities with Ingres Database > Differences in Constraint Checking
Was this helpful?
Differences in Constraint Checking
Constraint checking in Analytics Engine differs from traditional Ingres in the following ways:
• When loading data with COPY, if a constraint violation is detected, the entire dataset is rejected.
• When loading data with COPY, Analytics Engine detects foreign key (referential) constraint violations, unlike traditional Ingres.
• Analytics Engine does not handle cyclic constraints.
• Because of the optimistic concurrency control model (see Transaction Isolation Model) used by Analytics Engine, it is possible that a constraint violation is only detected at commit time.
 
Last modified date: 09/11/2026