On Tue, Mar 19, 2013 at 9:19 AM, Michael Paquier <michael.paqu...@gmail.com> wrote: > If failures happen with CREATE INDEX CONCURRENTLY, the system will be let > with invalid indexes. I don't think that the user would like to see invalid > indexes of > an existing system being recreated as valid after a restore. > So why not removing from a dump invalid indexes with something like the > patch > attached?
+1 The patch looks good to me. > This should perhaps be applied in pg_dump for versions down to 8.2 where > CREATE > INDEX CONCURRENTLY has been implemented? I think so. Regards, -- Fujii Masao -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers