pg_restore: Fix comment handling with --no-publications / --no-subscriptions.
authorFujii Masao <fujii@postgresql.org>
Tue, 16 Sep 2025 01:38:09 +0000 (10:38 +0900)
committerFujii Masao <fujii@postgresql.org>
Tue, 16 Sep 2025 01:38:09 +0000 (10:38 +0900)
commitc8ed1605056435bd617d661c87d02d64d8dde3ba
treeb5a5308aa55b010317e08efabc4580308e4a8bab
parent4529861cc40886ec57de185fa0fa55f2a0c08c25
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