Foreign Key constraint check

[eluser]ch5i[/eluser]
Thanks noctrum,

the problem is not really the database, it works as it should - prevents deletion of a child row and throws error 1451 (foreign key constraint failure).

Everything is working fine, just want to know how to detect and display the error with foreign key on delete, rather than display the CI error

The problem is when trying to delete a child row I'd like to tell the user that the child row cannot be deleted because it still has a parent.

You can prevent showing the error messages by disabling all db debug info in db config, but i'd prefer to do it in another way.