pgsql: Do not dump identity sequences with excluded parent table

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Do not dump identity sequences with excluded parent table
Date: 2018-08-22 05:24:17
Message-ID: E1fsLcv-0004cs-HA@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Do not dump identity sequences with excluded parent table

This commit prevents a crash of pg_dump caused by the exclusion of a
table which has identity columns, as the table would be correctly
excluded but not its identity sequence. In order to fix that, identity
sequences are excluded if the parent table is defined as such. Knowing
about such sequences has no meaning without their parent table anyway.

Reported-by: Andy Abelisto
Author: David Rowley
Reviewed-by: Peter Eisentraut, Michael Paquier
Discussion: https://postgr.es/m/153479393218.1316.8472285660264976457@wrigleys.postgresql.org
Backpatch-through: 10

Branch
------
REL_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/4ed59e02f5aa97618bb33355dc3accbcc2d5ace1

Modified Files
--------------
src/bin/pg_dump/pg_dump.c | 16 ++++++++++++++--
1 file changed, 14 insertions(+), 2 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Thomas Munro 2018-08-22 06:24:00 pgsql: Provide plan_cache_mode options in postgresql.conf.sample.
Previous Message Michael Paquier 2018-08-22 00:43:03 pgsql: Add regression tests for VACUUM and ANALYZE with relation skips