Home • Explore • Blog • CI
☰



postgresql
31th chunk of `doc/src/sgml/release-18.sgml`
0283f0fb2a35e0fc98cf65254b2f3351122ec4323a32d8930000000100000fa0
 url="&commit_baseurl;972c2cd28">&sect;</ulink>
</para>
</listitem>

<!--
Author: Tom Lane <tgl@sss.pgh.pa.us>
2025-03-26 [9324c8c58] Introduce PG_MODULE_MAGIC_EXT macro.
-->

<listitem>
<para>
Add macro PG_MODULE_MAGIC_EXT to allow extensions to report their name and version (Andrei Lepikhov)
<ulink url="&commit_baseurl;9324c8c58">&sect;</ulink>
</para>

<para>
This information can be access via the new function pg_get_loaded_modules().
</para>
</listitem>

<!--
Author: Tom Lane <tgl@sss.pgh.pa.us>
2024-09-09 [218527d01] Don't bother checking the result of SPI_connect[_ext] an
-->

<listitem>
<para>
Document that SPI_connect/SPI_connect_ext() always returns success (SPI_OK_CONNECT) (Stepan Neretin)
<ulink url="&commit_baseurl;218527d01">&sect;</ulink>
</para>

<para>
Errors are always reported via ereport().
</para>
</listitem>

<!--
Author: Peter Eisentraut <peter@eisentraut.org>
2025-01-27 [5afaba629] doc: Meson is not experimental on Windows
-->

<listitem>
<para>
Remove the experimental designation of Meson builds on Windows (Aleksander Alekseev)
<ulink url="&commit_baseurl;5afaba629">&sect;</ulink>
</para>
</listitem>

<!--
Author: Peter Eisentraut <peter@eisentraut.org>
2024-07-31 [e54a42ac9] Add API and ABI stability guidance to the C language doc
-->

<listitem>
<para>
Add documentation section about API and ABI compatibility (David Wheeler, Peter Eisentraut)
<ulink url="&commit_baseurl;e54a42ac9">&sect;</ulink>
</para>
</listitem>

<!--
Author: Thomas Munro <tmunro@postgresql.org>
2024-07-30 [e25626677] Remove - -disable-spinlocks.
Author: Thomas Munro <tmunro@postgresql.org>
2024-07-30 [813852613] Remove - -disable-atomics, require 32 bit atomics.
-->

<listitem>
<para>
Remove configure options --disable-spinlocks and --disable-atomics (Thomas Munro)
<ulink url="&commit_baseurl;e25626677">&sect;</ulink>
<ulink url="&commit_baseurl;813852613">&sect;</ulink>
</para>

<para>
Thirty-two bit atomic operations are now required.
</para>
</listitem>

<!--
Author: Tom Lane <tgl@sss.pgh.pa.us>
2024-07-01 [edadeb071] Remove support for HPPA (a/k/a PA-RISC) architecture.
-->

<listitem>
<para>
Remove support for the HPPA/PA-RISC architecture (Tom Lane)
<ulink url="&commit_baseurl;edadeb071">&sect;</ulink>
</para>
</listitem>

    </itemizedlist>

   </sect3>

   <sect3 id="release-18-modules">
    <title>Additional Modules</title>

    <itemizedlist>

<!--
Author: Masahiko Sawada <msawada@postgresql.org>
2024-10-14 [7cdfeee32] Add contrib/pg_logicalinspect.
-->

<listitem>
<para>
Add extension pg_logicalinspect to inspect logical snapshots (Bertrand Drouvot)
<ulink url="&commit_baseurl;7cdfeee32">&sect;</ulink>
</para>
</listitem>

<!--
Author: Robert Haas <rhaas@postgresql.org>
2025-03-26 [8d5ceb113] pg_overexplain: Additional EXPLAIN options for debugging
-->

<listitem>
<para>
Add extension pg_overexplain which adds debug details to EXPLAIN output (Robert Haas)
<ulink url="&commit_baseurl;8d5ceb113">&sect;</ulink>
</para>
</listitem>

<!--
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
Title: PostgreSQL 18: Build Updates, Documentation, and New Modules
Summary
This section covers build updates like requiring LLVM 14 if enabled, adding a macro for extension version reporting, and documenting that SPI_connect always returns success. It also includes documentation improvements related to API/ABI compatibility and removes configure options for disabling spinlocks and atomics. Furthermore, it removes support for the HPPA architecture. The section introduces new modules like pg_logicalinspect and pg_overexplain, along with enhancements to postgres_fdw_get_connections().