I am trying to determine what happens for a particular circular foreign key that will cascade delete. Please feel free to address any other possibilities that my inexperience has not listed.
On my root table, it links to one of its children's data via an initially deferred foreign key that cascade deletes.
If the child's row is deleted, will the parent be automatically deleted, or will some part fail? I want to delete by the child row because it's the most organized way to delete per my specific case. Or am I being unnecessarily fussy because a well designed view could do this for me?
If some part fails, how can my intent be implemented?
Note, I've read ypercube's answer, and it seems like it will behave as I expect, but I can't confirm in the docs, and that is for MySQL.
I've also read ypercube's recommendation, but if I only insert through a transaction, won't the check be deferred and self-delete if the columns aren't nullable? Or will an error be thrown instead, or some combination?