postgres_fdw, dblink: Validate use_scram_passthrough values

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: postgres_fdw, dblink: Validate use_scram_passthrough values
Date: 2026-05-27 14:41:58
Message-ID: CAHGQGwF+-k-Ehsu5W94ZP7GxS3wiBd+mi0PfGTdJ_i2Yr0zR3g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

The use_scram_passthrough option in postgres_fdw and dblink is
intended to accept only boolean values. However, unlike other boolean
options such as keep_connections, its value is not currently
validated.

As a result, invalid values are accepted unexpectedly, for example:

CREATE SERVER test_server
FOREIGN DATA WRAPPER postgres_fdw
OPTIONS (use_scram_passthrough 'invalid');

Attached patch updates postgres_fdw and dblink to validate
use_scram_passthrough values and throw an error for invalid input.

Regards,

--
Fujii Masao

Attachment Content-Type Size
v1-0001-postgres_fdw-dblink-Validate-use_scram_passthroug.patch application/octet-stream 1.9 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2026-05-27 15:53:35 Re: Avoid orphaned objects dependencies, take 3
Previous Message jian he 2026-05-27 14:06:27 Re: COPY ON_CONFLICT TABLE; save duplicated record to another table.