>> By the last sentence, do you mean only UPDATEs to the partition key that >> cause rows to jump partitions or simply any UPDATEs to the partition key? > > I don't know what Simon had in mind, but it seems to me that we have > the following in descending order of convenience to users, and I > presume, descending order of difficulty of implementation: > > 1. Updates propagate transparently, moving rows between partitions if needed. > > 2. Updates fail only if the change to a partition key would cause the > row to have to move to another partition. > > 3. All updates to the partition key fail. >