On 3/2/17 21:40, Robert Haas wrote: > On the point mentioned above, I > don't think adding a partition should move tuples, necessarily; seems > like it would be good enough - maybe better - for it to fail if there > are any that would need to be moved.
ISTM that the uses cases of various combinations of adding a default partition, adding another partition after it, removing the default partition, clearing out the default partition in order to add more nondefault partitions, and so on, need to be more clearly spelled out for each partitioning type. We also need to consider that pg_dump and pg_upgrade need to be able to reproduce all those states. Seems to be a bit of work still ... -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers