On 15 November 2017 at 01:09, Alvaro Herrera <alvhe...@alvh.no-ip.org> wrote: > if a > partition exists which *doesn't* have the index, restoring things this > way would create the index in that partition too, which is unwanted > because the end state is different to what was in the dumped database.
hmm, but surely the all those indexes must already exist if the partitioned index exists. Won't we be disallowing DROP INDEX of the leaf partition indexes if that index is marked as being part of the partitioned index? If so, then surely this could only happen if someone manually edited the pg_dump file to remove the CREATE INDEX statement for the leaf partition, and if they do that, then maybe they won't be so surprised that CREATE INDEX has to create some indexes. -- David Rowley http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
