On 14 February 2017 at 22:24, David Fetter <da...@fetter.org> wrote: > On Mon, Feb 13, 2017 at 05:31:56PM +0530, Amit Khandekar wrote: >> Currently, an update of a partition key of a partition is not >> allowed, since it requires to move the row(s) into the applicable >> partition. >> >> Attached is a WIP patch (update-partition-key.patch) that removes >> this restriction. When an UPDATE causes the row of a partition to >> violate its partition constraint, then a partition is searched in >> that subtree that can accommodate this row, and if found, the row is >> deleted from the old partition and inserted in the new partition. If >> not found, an error is reported. > > This is great! > > Would it be really invasive to HINT something when the subtree is a > proper subtree?
I am not quite sure I understood this question. Can you please explain it a bit more ... -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers