]> 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:37:38 +0000 (10:37 +0900)
committerFujii Masao <fujii@postgresql.org>
Tue, 16 Sep 2025 01:37:38 +0000 (10:37 +0900)
commit97527a5e68d523048fd80aa1c97c3fe5bf948fb6
treefb9eae90b9ec2871f742b8526fa1f83abdf12653
parentf30c04682cdf3a2fb48c0ab47017b28ef92bbebf
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