It does but the solution is mundane: use an auto generated primary key.