pgsql: Fix pg_dump --clean with partitioned indexes.
| От | Tom Lane |
|---|---|
| Тема | pgsql: Fix pg_dump --clean with partitioned indexes. |
| Дата | |
| Msg-id | E1u56cL-000MMY-09@gemulon.postgresql.org обсуждение исходный текст |
| Список | pgsql-committers |
Fix pg_dump --clean with partitioned indexes. We'd try to drop the partitions of a partitioned index separately, which is disallowed by the backend, leading to an error during restore. While the error is harmless, it causes problems if you try to use --single-transaction mode. Fortunately, there seems no need to do a DROP at all, since the partition will go away silently when we drop either the parent index or the partition's table. So just make the DROP conditional on not being a partition. Reported-by: jian he <jian.universality@gmail.com> Author: jian he <jian.universality@gmail.com> Reviewed-by: Pavel Stehule <pavel.stehule@gmail.com> Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us> Discussion: https://postgr.es/m/CACJufxF0QSdkjFKF4di-JGWN6CSdQYEAhGPmQJJCdkSZtd=oLg@mail.gmail.com Backpatch-through: 13 Branch ------ REL_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/148cc0105dce93b52fe9e801f51ae0e3fbf96af1 Modified Files -------------- src/bin/pg_dump/pg_dump.c | 26 ++++++++++++++++++++------ 1 file changed, 20 insertions(+), 6 deletions(-)
В списке pgsql-committers по дате отправления: