]> git.ipfire.org Git - thirdparty/postgresql.git/commit
postgres_fdw, dblink: Validate use_scram_passthrough values
authorFujii Masao <fujii@postgresql.org>
Thu, 28 May 2026 11:58:08 +0000 (20:58 +0900)
committerFujii Masao <fujii@postgresql.org>
Thu, 28 May 2026 11:58:08 +0000 (20:58 +0900)
commit8a86aa313a714adc56c74e4b08793e4e6102b5ca
tree06c19e0200acfe03475dbf6d605ea54d2d1b913b
parentd79bf7612a07a6f053f4122a8bf88754217cd1c9
postgres_fdw, dblink: Validate use_scram_passthrough values

The use_scram_passthrough option in postgres_fdw and dblink accepts
only boolean values. However, unlike other boolean options such as
keep_connections, its value was not previously validated.

As a result, commands such as
"CREATE SERVER ... OPTIONS (use_scram_passthrough 'invalid')"
could succeed unexpectedly.

This commit updates postgres_fdw and dblink to validate that
use_scram_passthrough is assigned a valid boolean value, and throw an
error for invalid input.

Backpatch to v18, where use_scram_passthrough was introduced.

Author: Fujii Masao <masao.fujii@gmail.com>
Reviewed-by: Ayush Tiwari <ayushtiwari.slg01@gmail.com>
Reviewed-by: Matheus Alcantara <matheusssilv97@gmail.com>
Discussion: https://postgr.es/m/CAHGQGwF+-k-Ehsu5W94ZP7GxS3wiBd+mi0PfGTdJ_i2Yr0zR3g@mail.gmail.com
Backpatch-through: 18
contrib/dblink/dblink.c
contrib/postgres_fdw/option.c