| 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 |
| 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. |