Putting your dog down when you die?

We hear about worries that dog owners want their pets put down when they die.