Home Explore Blog CI



postgresql

32th chunk of `doc/src/sgml/release-18.sgml`
e3d9fa99c98bc80bc32b180cf8e74af95e0ac519578002b10000000100000fa2

Author: Fujii Masao <fujii@postgresql.org>
2024-07-26 [c297a47c5] postgres_fdw: Add "used_in_xact" column to postgres_fdw_
Author: Fujii Masao <fujii@postgresql.org>
2024-07-26 [857df3cef] postgres_fdw: Add connection status check to postgres_fd
Author: Fujii Masao <fujii@postgresql.org>
2024-09-18 [4f08ab554] postgres_fdw: Extend postgres_fdw_get_connections to ret
Author: Fujii Masao <fujii@postgresql.org>
2025-03-03 [fe186bda7] postgres_fdw: Extend postgres_fdw_get_connections to ret
-->

<listitem>
<para>
Add output columns to postgres_fdw_get_connections() (Hayato Kuroda, Sagar Dilip Shedge)
<ulink url="&commit_baseurl;c297a47c5">&sect;</ulink>
<ulink url="&commit_baseurl;857df3cef">&sect;</ulink>
<ulink url="&commit_baseurl;4f08ab554">&sect;</ulink>
<ulink url="&commit_baseurl;fe186bda7">&sect;</ulink>
</para>

<para>
New output column "used_in_xact" indicates if the foreign data wrapper is being used by a current transaction, "closed" indicates if it is closed, "user_name" indicates the
user name, and "remote_backend_pid" indicates the remote backend process identifier.
</para>
</listitem>

<!--
Author: Peter Eisentraut <peter@eisentraut.org>
2025-01-15 [761c79508] postgres_fdw: SCRAM authentication pass-through
-->

<listitem>
<para>
Allow SCRAM authentication from the client to be passed to postgres_fdw servers (Matheus Alcantara, Peter Eisentraut)
<ulink url="&commit_baseurl;761c79508">&sect;</ulink>
</para>

<para>
This avoids storing postgres_fdw authentication information in the database, and is enabled with the postgres_fdw "use_scram_passthrough" connection option.  libpq uses new connection
parameters scram_client_key and scram_server_key.
</para>
</listitem>

<!--
Author: Peter Eisentraut <peter@eisentraut.org>
2025-03-26 [3642df265] dblink: SCRAM authentication pass-through
-->

<listitem>
<para>
Allow SCRAM authentication from the client to be passed to dblink servers (Matheus Alcantara)
<ulink url="&commit_baseurl;3642df265">&sect;</ulink>
</para>
</listitem>

<!--
Author: Fujii Masao <fujii@postgresql.org>
2024-10-03 [a1c4c8a9e] file_fdw: Add on_error and log_verbosity options to file
-->

<listitem>
<para>
Add on_error and log_verbosity options to file_fdw (Atsushi Torikoshi)
<ulink url="&commit_baseurl;a1c4c8a9e">&sect;</ulink>
</para>

<para>
These control how file_fdw handles and reports invalid file rows.
</para>
</listitem>

<!--
Author: Fujii Masao <fujii@postgresql.org>
2024-11-20 [6c8f67032] file_fdw: Add REJECT_LIMIT option to file_fdw.
-->

<listitem>
<para>
Add "reject_limit" to control the number of invalid rows file_fdw can ignore (Atsushi Torikoshi)
<ulink url="&commit_baseurl;6c8f67032">&sect;</ulink>
</para>

<para>
This is active when ON_ERROR = 'ignore'.
</para>
</listitem>

<!--
Author: Nathan Bossart <nathan@postgresql.org>
2025-01-07 [f7e1b3828] Add passwordcheck.min_password_length.
-->

<listitem>
<para>
Add configurable variable min_password_length to passwordcheck (Emanuele Musella, Maurizio Boriani)
<ulink url="&commit_baseurl;f7e1b3828">&sect;</ulink>
</para>

<para>
This controls the minimum password length.
</para>
</listitem>

<!--
Author: Tatsuo Ishii <ishii@postgresql.org>
2024-10-11 [cae0f3c40] pgbench: Improve result outputs related to failed transa
-->

<listitem>
<para>
Have pgbench report the number of failed, retried, or skipped transactions in per-script reports (Yugo Nagata)
<ulink url="&commit_baseurl;cae0f3c40">&sect;</ulink>
</para>
</listitem>

<!--
Author: Tom Lane <tgl@sss.pgh.pa.us>
2025-03-16 [448904423] contrib/isn: Make weak mode a GUC setting, and fix relat
-->

<listitem>
<para>
Add isn server variable "weak" to control invalid check digit acceptance (Viktor Holmberg)
<ulink url="&commit_baseurl;448904423">&sect;</ulink>
</para>

<para>
This was previously only controlled by function isn_weak().
</para>
</listitem>

<!--
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
2025-04-03 [e4309f73f] Add support for sorted gist index builds to btree_gist
-->

Title: PostgreSQL 18: Foreign Data Wrapper and Utility Enhancements
Summary
This section details enhancements to foreign data wrappers and utility modules. It includes adding output columns to postgres_fdw_get_connections(), allowing SCRAM authentication passthrough for postgres_fdw and dblink, adding on_error and reject_limit options to file_fdw, introducing a configurable min_password_length to passwordcheck, and enhancing pgbench to report failed/retried transactions. Finally, it adds an isn server variable to control invalid check digit acceptance.