From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Fix parallel restore of FKs to partitioned tables |
Date: | 2019-10-17 08:08:59 |
Message-ID: | E1iL0qB-0004Ct-2A@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Fix parallel restore of FKs to partitioned tables
When an FK constraint is created, it needs the index on the referenced
table to exist and be valid. When doing parallel pg_restore and the
referenced table was partitioned, this condition can sometimes not be
met, because pg_dump didn't emit sufficient object dependencies to
ensure so; this means that parallel pg_restore would fail in certain
conditions. Fix by having pg_dump make the FK constraint object
dependent on the partition attachment objects for the constraint's
referenced index.
This has been broken since f56f8f8da6af, so backpatch to Postgres 12.
Discussion: https://postgr.es/m/20191005224333.GA9738@alvherre.pgsql
Branch
------
REL_12_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/b304b2b65fde057a35286adf3ea69f5e154d1878
Modified Files
--------------
src/bin/pg_dump/common.c | 3 +++
src/bin/pg_dump/pg_dump.c | 42 ++++++++++++++++++++++++++++++++++++--
src/bin/pg_dump/pg_dump.h | 2 ++
src/fe_utils/simple_list.c | 21 +++++++++++++++++++
src/include/fe_utils/simple_list.h | 19 ++++++++++++++---
5 files changed, 82 insertions(+), 5 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2019-10-17 13:12:06 | pgsql: Fix minor bug in logical-replication walsender shutdown |
Previous Message | Alvaro Herrera | 2019-10-17 06:36:37 | Re: pgsql: Fix bug that could try to freeze running multixacts. |