So it turns out that if you try to delete the stacked on branch, you get an OOPS:
Retry: update or delete on table "branch" violates foreign key constraint "branch_stacked_on_fkey" on table "branch"<br /> DETAIL: Key (id)=(77) is still referenced from table "branch".<br /> <br />
This isn't good, though probably better than allowing the branch to be deleted...
So it turns out that if you try to delete the stacked on branch, you get an OOPS:
Retry: update or delete on table "branch" violates foreign key constraint "branch_ stacked_ on_fkey" on table "branch"<br /> DETAIL: Key (id)=(77) is still referenced from table "branch".<br /> <br />
This isn't good, though probably better than allowing the branch to be deleted...