Hi,
It was reported in [1] that Reindex Concurrently for indexes with
deferrable constraints doesn't honour the deferrable constraints while
the operations is running. And the transactions can fail because the
constraint is enforced before commit.
I'm proposing a patch here which correctly copies the flag from the
old index to the new one. Please take a look.
[1] https://www.postgresql.org/message-id/flat/cc0470801d4ee46bd85f94c2516fd31b%40nimrod.no
Regards & Thanks,
Nitin Motiani
Google