pgsql: Allow resetting unknown custom GUCs with reserved prefixes.

2025-08-01 Thread Nathan Bossart
Allow resetting unknown custom GUCs with reserved prefixes. Currently, ALTER DATABASE/ROLE/SYSTEM RESET [ALL] with an unknown custom GUC with a prefix reserved by MarkGUCPrefixReserved() errors (unless a superuser runs a RESET ALL variant). This is problematic for cases such as an extension libra

pgsql: Allow resetting unknown custom GUCs with reserved prefixes.

2025-08-01 Thread Nathan Bossart
Allow resetting unknown custom GUCs with reserved prefixes. Currently, ALTER DATABASE/ROLE/SYSTEM RESET [ALL] with an unknown custom GUC with a prefix reserved by MarkGUCPrefixReserved() errors (unless a superuser runs a RESET ALL variant). This is problematic for cases such as an extension libra

pgsql: Allow resetting unknown custom GUCs with reserved prefixes.

2025-08-01 Thread Nathan Bossart
Allow resetting unknown custom GUCs with reserved prefixes. Currently, ALTER DATABASE/ROLE/SYSTEM RESET [ALL] with an unknown custom GUC with a prefix reserved by MarkGUCPrefixReserved() errors (unless a superuser runs a RESET ALL variant). This is problematic for cases such as an extension libra

pgsql: Allow resetting unknown custom GUCs with reserved prefixes.

2025-08-01 Thread Nathan Bossart
Allow resetting unknown custom GUCs with reserved prefixes. Currently, ALTER DATABASE/ROLE/SYSTEM RESET [ALL] with an unknown custom GUC with a prefix reserved by MarkGUCPrefixReserved() errors (unless a superuser runs a RESET ALL variant). This is problematic for cases such as an extension libra

pgsql: Allow resetting unknown custom GUCs with reserved prefixes.

2025-08-01 Thread Nathan Bossart
Allow resetting unknown custom GUCs with reserved prefixes. Currently, ALTER DATABASE/ROLE/SYSTEM RESET [ALL] with an unknown custom GUC with a prefix reserved by MarkGUCPrefixReserved() errors (unless a superuser runs a RESET ALL variant). This is problematic for cases such as an extension libra

pgsql: Fix a deadlock during ALTER SUBSCRIPTION ... DROP PUBLICATION.

2025-08-01 Thread Amit Kapila
Fix a deadlock during ALTER SUBSCRIPTION ... DROP PUBLICATION. A deadlock can occur when the DDL command and the apply worker acquire catalog locks in different orders while dropping replication origins. The issue is rare in PG16 and higher branches because, in most cases, the tablesync worker pe

pgsql: Fix a deadlock during ALTER SUBSCRIPTION ... DROP PUBLICATION.

2025-08-01 Thread Amit Kapila
Fix a deadlock during ALTER SUBSCRIPTION ... DROP PUBLICATION. A deadlock can occur when the DDL command and the apply worker acquire catalog locks in different orders while dropping replication origins. The issue is rare in PG16 and higher branches because, in most cases, the tablesync worker pe

pgsql: Fix a deadlock during ALTER SUBSCRIPTION ... DROP PUBLICATION.

2025-08-01 Thread Amit Kapila
Fix a deadlock during ALTER SUBSCRIPTION ... DROP PUBLICATION. A deadlock can occur when the DDL command and the apply worker acquire catalog locks in different orders while dropping replication origins. The issue is rare in PG16 and higher branches because, in most cases, the tablesync worker pe

pgsql: Fix a deadlock during ALTER SUBSCRIPTION ... DROP PUBLICATION.

2025-08-01 Thread Amit Kapila
Fix a deadlock during ALTER SUBSCRIPTION ... DROP PUBLICATION. A deadlock can occur when the DDL command and the apply worker acquire catalog locks in different orders while dropping replication origins. The issue is rare in PG16 and higher branches because, in most cases, the tablesync worker pe

pgsql: Fix a deadlock during ALTER SUBSCRIPTION ... DROP PUBLICATION.

2025-08-01 Thread Amit Kapila
Fix a deadlock during ALTER SUBSCRIPTION ... DROP PUBLICATION. A deadlock can occur when the DDL command and the apply worker acquire catalog locks in different orders while dropping replication origins. The issue is rare in PG16 and higher branches because, in most cases, the tablesync worker pe

pgsql: Fix a deadlock during ALTER SUBSCRIPTION ... DROP PUBLICATION.

2025-08-01 Thread Amit Kapila
Fix a deadlock during ALTER SUBSCRIPTION ... DROP PUBLICATION. A deadlock can occur when the DDL command and the apply worker acquire catalog locks in different orders while dropping replication origins. The issue is rare in PG16 and higher branches because, in most cases, the tablesync worker pe

pgsql: libpq: Complain about missing BackendKeyData later with PGgetCan

2025-08-01 Thread Heikki Linnakangas
libpq: Complain about missing BackendKeyData later with PGgetCancel() PostgreSQL always sends the BackendKeyData message at connection startup, but there are some third party backend implementations out there that don't support cancellation, and don't send the message [1]. While the protocol docs

pgsql: libpq: Complain about missing BackendKeyData later with PGgetCan

2025-08-01 Thread Heikki Linnakangas
libpq: Complain about missing BackendKeyData later with PGgetCancel() PostgreSQL always sends the BackendKeyData message at connection startup, but there are some third party backend implementations out there that don't support cancellation, and don't send the message [1]. While the protocol docs

pgsql: pg_dump: reject combination of "only" and "with"

2025-08-01 Thread Jeff Davis
pg_dump: reject combination of "only" and "with" Reviewed-by: Álvaro Herrera Discussion: https://postgr.es/m/[email protected] Backpatch-through: 18 Branch -- REL_18_STABLE Details --- https://git.postgresql.org/pg/commitdiff/60121890f7f23311c1e

pgsql: pg_dump: reject combination of "only" and "with"

2025-08-01 Thread Jeff Davis
pg_dump: reject combination of "only" and "with" Reviewed-by: Álvaro Herrera Discussion: https://postgr.es/m/[email protected] Backpatch-through: 18 Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/0ed92cf50cc428dad1732a5e60

pgsql: Fix typo in AutoVacLauncherMain().

2025-08-01 Thread Masahiko Sawada
Fix typo in AutoVacLauncherMain(). Author: Yugo Nagata Discussion: https://postgr.es/m/[email protected] Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/a2c6c4ed3145a411c2591ebd7ca14f30dd98b896 Modified Files -- src/