>So, is it the consenus then that it is a bad/dangerous thing to name my Primary index "PRIMARY"?

This is an interesting discussion. I think we've all been in that situation once.

More than that, we also have to think ahead. Which means, a word used in code, index definition, etc., might be available to use now but may become a reserved word for upcoming versions.