| From: | Nitin Motiani <nitinmotiani(at)google(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | [PATCH v1] Fix propagation of indimmediate flag in index_create_copy |
| Date: | 2026-07-20 17:39:44 |
| Message-ID: | CAH5HC97JmjPpgiQOqW9xm8qXhNiu7zZ1Qh+FfhEESJuDv69kuQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| Attachment | Content-Type | Size |
|---|---|---|
| v1-0001-Fix-propagation-of-indimmediate-flag-in-index_cre.patch | application/x-patch | 7.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Antonin Houska | 2026-07-20 17:48:37 | Re: Unexpected behavior after OOM errors |
| Previous Message | Álvaro Herrera | 2026-07-20 17:21:11 | Re: [PATCH] Don't call ereport(ERROR) from recovery target GUC assign hooks |