pg_restore: Fix comment handling with --no-publications / --no-subscriptions.
authorFujii Masao <fujii@postgresql.org>
Tue, 16 Sep 2025 01:38:40 +0000 (10:38 +0900)
committerFujii Masao <fujii@postgresql.org>
Tue, 16 Sep 2025 01:38:40 +0000 (10:38 +0900)
commitdb900ec358bd0ffa59b60a906f2ddc5305bc6b8b
treeb5860cce654e95b53281049f65b7fe5da55f787f
parentcbd3732cbbaa0fa083a12ca2d9df18ff606736da
pg_restore: Fix comment handling with --no-publications / --no-subscriptions.

Previously, pg_restore did not skip comments on publications or subscriptions
even when --no-publications or --no-subscriptions was specified. As a result,
it could issue COMMENT commands for objects that were never created,
causing those commands to fail.

This commit fixes the issue by ensuring that comments on publications and
subscriptions are also skipped when the corresponding options are used.

Backpatch to all supported versions.

Author: Jian He <jian.universality@gmail.com>
Co-authored-by: Fujii Masao <masao.fujii@gmail.com>
Discussion: https://postgr.es/m/CACJufxHCt00pR9h51AVu6+yPD5J7JQn=7dQXxqacj0XyDhc-fA@mail.gmail.com
Backpatch-through: 13
src/bin/pg_dump/pg_backup_archiver.c
src/bin/pg_dump/t/002_pg_dump.pl