ALL puppies are great with kids if trained properly :)
Although like the others said smaller dogs are actually more un-suitable ,they are more fragile and as you know kids treat everything like toys.. screaming,tugging,pulling. So smaller dogs are not a good idea, although my neighbour's jack russell terrier is adorable and so patient.
Your fiance does have a good idea, big dogs are only dangerous if they are raised to be dangerous ! :) I have owned lots of bullies and staffies and they were always so good behaved and wouldn't hurt a fly.
I've grown up around dogs and my parents always taught me that no dog is dangerous becasue of itself but becasue of the owner and like the saying goes "we should never judge a book by its cover".
BIg dogs are very lovable and if you discipline them they will be loyal and love you forever and protect you from strangers (bad strangers), becasue what could a chihuahua do ? Lick an attacker to death ?
You should be looking for a dog becasue you truly want one, remember dogs live up to 15 years or more and they will always depend on you. You should read on forums about dogs, preferably find a different forum for each breed eg a great dane forum for great danes, an irish setter forum for irish setters becasue many people are VERY judgemental (sp?)
"Your fiance' is an idiot. Pit Bulls have been know to maul toddlers to death.A small toy type of dog is way to small and their temperment is not good for a child as young as yours. Look for medium sized dogs like Springer Spaniels which are protective and gentle with kids.Do not get any type of terrier.they are too full of energy and don't care for kids much. I am really not sure that a child you boys age and a small dog is a good idea.I think you should wait and don't listen to your fiance'."
Listen to yourself, that's the image that the media created and planted into naive people's minds like yours, I bet there are just as many dog attack on toddlers by labradors or other "friendly" dogs, just the media doesn't tell us about it. You must have 30 years of experience with tiny dogs becasue no true dog lover/breeder would ever say that.
ANd you know why ?
Because many attacks are unreported
Many see some pitbull similar breed and they're like "omg a pitbull attack !" when it's not a pitbull.
Here are some quotes :
"Some dogs that have a bad image and are considered aggressive are the Boxer, Bulldogs, Pit Bull Terriers, Great Danes, Mastiffs, German Shepherds and Rottweilers. According to this study this is how they ranked:
Great Dane: 9. This breed is actually very patient, gentle and affectionate. Although its size can be an issue with small children, it gets on well with children.
Rottweilers: 15. This dog is very loyal and can be fiercely protective which may cause it to be aggressive. However, it is a hard working, powerful, devoted dog that gets on well with children if they are brought up with them.
Boxer: 16. These dogs are actually good with children. They make good watchdogs. As they have a protective nature; they may be aggressive if they feel their owner is being threatened.
German Shepherds (Alsatians): 17. An alert, loyal, courageous and intelligent breed. These dogs are good with children and they are very protective making them effective watchdogs.
Mastiffs: 21. These dogs are very dignified, loyal creatures with a pleasant nature, resembling gentle giants. Their size means they can be a problem with small children, but they get on well with children."
See all are good with children ? :) Just a matter of how you raise them , so don't worry about a rottweiler ,it will actually be a very good choice !