Horton

pg_restore: Fix comment handling with --no-policies.

Fujii Masao <fujii@postgresql.org>

View on postgr.es
Commit: 2ddbfede0c615c009bbbb0f8dfcaa848da5d2376
Author: Fujii Masao <fujii@postgresql.org>
Date: 2025-09-16T02:55:10Z
Releases: 18.0 
pg_restore: Fix comment handling with --no-policies.

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

This commit fixes the issue by ensuring that comments on policies
are also skipped when --no-policies is used.

Backpatch to v18, where --no-policies was added in pg_restore.

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: 18

Files

PathChange+/−
src/bin/pg_dump/pg_backup_archiver.c modified +6 −1
src/bin/pg_dump/t/002_pg_dump.pl modified +46 −0

Discussion