Column that must be unique only for rows with matching foreign key
I would like for Child.name to be unique, but only for members of Child where Child.parent_id is the same. 


This mean you need NOT (Child.name) to be unique. 
You need in (Child.name, Child.parent_id) to be unique.