Home • Explore • Blog • CI
☰



postgresql
30th chunk of `doc/src/sgml/release-18.sgml`
85f8f0e19a1eabaa8676e1462349962b65a8fbec8e6bfdf90000000100000fa5
 pg_attribute.attcacheoff (David Rowley)
<ulink url="&commit_baseurl;02a8d0c45">&sect;</ulink>
</para>
</listitem>

<!--
Author: Melanie Plageman <melanieplageman@gmail.com>
2025-03-03 [99f8f3fbb] Add relallfrozen to pg_class
-->

<listitem>
<para>
Add column pg_class.relallfrozen (Melanie Plageman)
<ulink url="&commit_baseurl;99f8f3fbb">&sect;</ulink>
</para>
</listitem>

<!--
Author: Peter Eisentraut <peter@eisentraut.org>
2024-09-10 [56fead44d] Add amgettreeheight index AM API routine
Author: Peter Eisentraut <peter@eisentraut.org>
2025-03-07 [af4002b38] Rename amcancrosscompare
-->

<listitem>
<para>
Add amgettreeheight, amconsistentequality, and amconsistentordering to the index access method API (Mark Dilger)
<ulink url="&commit_baseurl;56fead44d">&sect;</ulink>
<ulink url="&commit_baseurl;af4002b38">&sect;</ulink>
</para>
</listitem>

<!--
Author: Peter Eisentraut <peter@eisentraut.org>
2024-09-17 [7406ab623] Add stratnum GiST support function
-->

<listitem>
<para>
Add GiST support function stratnum (Paul A. Jungwirth)
<ulink url="&commit_baseurl;7406ab623">&sect;</ulink>
</para>
</listitem>

<!--
Author: Masahiko Sawada <msawada@postgresql.org>
2025-02-21 [44fe30fda] Add default_char_signedness field to ControlFileData.
-->

<listitem>
<para>
Record the default CPU signedness of "char" in pg_controldata (Masahiko Sawada)
<ulink url="&commit_baseurl;44fe30fda">&sect;</ulink>
</para>
</listitem>

<!--
Author: Peter Eisentraut <peter@eisentraut.org>
2025-03-12 [72a3d0462] Prepare for Python "Limited API" in PL/Python
Author: Peter Eisentraut <peter@eisentraut.org>
2025-03-14 [0793ab810] Activate Python "Limited API" in PL/Python
-->

<listitem>
<para>
Add support for Python "Limited API" in PL/Python (Peter Eisentraut)
<ulink url="&commit_baseurl;72a3d0462">&sect;</ulink>
<ulink url="&commit_baseurl;0793ab810">&sect;</ulink>
</para>

<para>
This helps prevent problems caused by Python 3.x version mismatches.
</para>
</listitem>

<!--
Author: Jacob Champion <jchampion@postgresql.org>
2025-04-29 [45363fca6] Bump the minimum supported Python version to 3.6.8
-->

<listitem>
<para>
Change the minimum supported Python version to 3.6.8 (Jacob Champion)
<ulink url="&commit_baseurl;45363fca6">&sect;</ulink>
</para>
</listitem>

<!--
Author: Daniel Gustafsson <dgustafsson@postgresql.org>
2024-09-02 [a70e01d43] Remove support for OpenSSL older than 1.1.0
Author: Daniel Gustafsson <dgustafsson@postgresql.org>
2024-10-24 [6c66b7443] Raise the minimum supported OpenSSL version to 1.1.1
-->

<listitem>
<para>
Remove support for OpenSSL versions older than 1.1.1 (Daniel Gustafsson)
<ulink url="&commit_baseurl;a70e01d43">&sect;</ulink>
<ulink url="&commit_baseurl;6c66b7443">&sect;</ulink>
</para>
</listitem>

<!--
Author: Peter Eisentraut <peter@eisentraut.org>
2024-10-01 [972c2cd28] jit: Require at least LLVM 14, if enabled.
-->

<listitem>
<para>
If LLVM is enabled, require version 14 or later (Thomas Munro)
<ulink 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
Title: PostgreSQL 18: Catalog Changes, API Updates, and Dependency Upgrades
Summary
This section details changes to the PostgreSQL catalog, including the removal of pg_attribute.attcacheoff, the addition of pg_class.relallfrozen, and new functions in the index access method API, such as amgettreeheight. It also covers the addition of a GiST support function, recording CPU "char" signedness, and the introduction of Python "Limited API" support in PL/Python. Furthermore, it discusses raising the minimum supported Python and OpenSSL versions, requiring LLVM 14 or later, and adding a macro for extensions to report their name and version.