bryanastarte wrote:

>
> When I try to delete all the rows from the table using "delete from
> category" I get a foreign key viloation. I don't believe this should
> happen as the "delete from" should delete all the data in the table
> and should not care about foreign keys within the same table.

In theory, the constraint should be evaluated after the verb, not after
each record operation. In practice, Firebird evaluates constraints
after record operations. That's a holdover from its original design
which did not have mass update operations.

For now, your choices are to drop the constraint before the operation,
add an "on delete cascade", or delete the tree from the bottom up.

Regards,


Ann