That and why not allow null for the foreign key constraint and set it to nullify upon deletion? Or indeed, anonymise data.
So I'm torn, because I think there may just be a major problem I've not yet grown my apps big enough to suffer. Anyone have thoughts either way?