If you specify CASCADE when creating a Foreign Key, Pervasive PSQL uses the DELETE CASCADE rule. When a user deletes a row in the parent table, Pervasive PSQL deletes the corresponding rows in the dependent table.

Use caution with delete cascade. Pervasive PSQL allows a circular delete cascade on a table that references itself. See examples in Delete Cascade in Advanced Operations Guide.