It would appear from Google Images that Steve is basically correct. That being said, out here in Arizona I've never heard the term "stockade fence" used. The "pointy headed" vs. "blunt headed" distinction is definitely incorrect. Stockade fence sounds vaguely military, and that in fact is the origin (military and frontier stockades) - so I would think CTers would prefer it. For that matter, I've never heard anyone call anything out here a "grassy knoll," either. I do have a "pergola" in my back yard, although I didn't know that's what it was called either until the contractor called it that.
Now that I'm working on a law review article on this topic, it seems that the logs of frontier stockade fences did have pointy bottoms to facilitate driving them into the ground. Beginning in approximately 1873 ... oh, never mind.