Re: pgsql: Allow UPDATE to move rows between partitions.

2018-01-23 Thread Amit Kapila
On Sat, Jan 20, 2018 at 2:03 AM, Robert Haas wrote: > Allow UPDATE to move rows between partitions. > +If an UPDATE on a partitioned table causes a row to move +to another partition, it will be performed as a DELETE +from the original partition followed by an INSERT into +the new

pgsql: Allow UPDATE to move rows between partitions.

2018-01-19 Thread Robert Haas
Allow UPDATE to move rows between partitions. When an UPDATE causes a row to no longer match the partition constraint, try to move it to a different partition where it does match the partition constraint. In essence, the UPDATE is split into a DELETE from the old partition and an INSERT into the