]> git.ipfire.org Git - thirdparty/postgresql.git/commit
pg_restore: Fix comment handling with --no-publications / --no-subscriptions.
authorFujii Masao <fujii@postgresql.org>
Tue, 16 Sep 2025 01:35:12 +0000 (10:35 +0900)
committerFujii Masao <fujii@postgresql.org>
Tue, 16 Sep 2025 01:36:20 +0000 (10:36 +0900)
commit77d2b155caf716354a3519233f2cef3369984a65
tree3707ccab4f254226413b0719c3992462086f3c88
parente7a2bbdb522dd6fc7283550742b8b52605198783
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