that was interesting, but it felt like two different articles rolled into one (a short non-technical and a long-but-shorter-than-that technical one).

anyway, so alter table modify on a primary key (int to bigint) requires that the index be rebuilt? is that true for all databases? or was the problem something else?