[jowea]

You could make a special primary key column creation function that rejects static values.

[tazjin]

You don't even have to reject/forbid them, just make their use explicit.