Re: Declarative partitioning

On 2015-08-21 AM 06:27, David Fetter wrote:

>> 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.
>

I was thinking I'd implement 2.