Home • Explore • Blog • CI
☰



postgresql
14th chunk of `doc/src/sgml/release-18.sgml`
041cc46fbda072cfa34623fcb4c2975aae2308a28cae3af90000000100000fa3
 columns when specified in the column
Author: Amit Kapila <akapila@postgresql.org>
2024-11-07 [7054186c4] Replicate generated columns when 'publish_generated_colu
Author: Amit Kapila <akapila@postgresql.org>
2024-12-04 [87ce27de6] Ensure stored generated columns must be published when r
Author: Amit Kapila <akapila@postgresql.org>
2025-01-30 [6252b1eaf] Doc: Generated column replication.
-->

<listitem>
<para>
Allow the values of generated columns to be logically replicated (Shubham Khanna, Vignesh C, Zhijie Hou, Shlok Kyal, Peter Smith)
<ulink url="&commit_baseurl;745217a05">&sect;</ulink>
<ulink url="&commit_baseurl;7054186c4">&sect;</ulink>
<ulink url="&commit_baseurl;87ce27de6">&sect;</ulink>
<ulink url="&commit_baseurl;6252b1eaf">&sect;</ulink>
</para>

<para>
If the publication specifies a column list, all specified columns, generated and non-generated, are published.  Without a specified column list, publication option publish_generated_columns
controls whether generated columns are published. Previously generated columns were not replicated and the subscriber had to compute the values if possible;  this is particularly
useful for non-Postgres subscribers which lack such a capability.
</para>
</listitem>

<!--
Author: Amit Kapila <akapila@postgresql.org>
2024-10-28 [1bf1140be] Change the default value of the streaming option to 'par
-->

<listitem>
<para>
Change the default CREATE SUBSCRIPTION streaming option from "off" to "parallel" (Vignesh C)
<ulink url="&commit_baseurl;1bf1140be">&sect;</ulink>
</para>
</listitem>

<!--
Author: Amit Kapila <akapila@postgresql.org>
2024-07-24 [1462aad2e] Allow altering of two_phase option of a SUBSCRIPTION.
Author: Amit Kapila <akapila@postgresql.org>
2025-04-03 [4868c96bc] Fix slot synchronization for two_phase enabled slots.
-->

<listitem>
<para>
Allow ALTER SUBSCRIPTION to change the replication slot's two-phase commit behavior (Hayato Kuroda, Ajin Cherian, Amit Kapila, Zhijie Hou)
<ulink url="&commit_baseurl;1462aad2e">&sect;</ulink>
<ulink url="&commit_baseurl;4868c96bc">&sect;</ulink>
</para>
</listitem>

<!--
Author: Amit Kapila <akapila@postgresql.org>
2024-08-20 [9758174e2] Log the conflicts while applying changes in logical repl
Author: Amit Kapila <akapila@postgresql.org>
2024-08-22 [edcb71258] Doc: explain the log format of logical replication confl
Author: Amit Kapila <akapila@postgresql.org>
2024-08-29 [640178c92] Rename the conflict types for the origin differ cases.
Author: Amit Kapila <akapila@postgresql.org>
2024-09-04 [6c2b5edec] Collect statistics about conflicts in logical replicatio
Author: Amit Kapila <akapila@postgresql.org>
2025-03-24 [73eba5004] Detect and Log multiple_unique_conflicts type conflict.
-->

<listitem>
<para>
Log conflicts while applying logical replication changes (Zhijie Hou, Nisha Moond)
<ulink url="&commit_baseurl;9758174e2">&sect;</ulink>
<ulink url="&commit_baseurl;edcb71258">&sect;</ulink>
<ulink url="&commit_baseurl;640178c92">&sect;</ulink>
<ulink url="&commit_baseurl;6c2b5edec">&sect;</ulink>
<ulink url="&commit_baseurl;73eba5004">&sect;</ulink>
</para>

<para>
Also report in new columns of pg_stat_subscription_stats.
</para>
</listitem>

     </itemizedlist>

    </sect4>

   </sect3>

   <sect3 id="release-18-utility">
    <title>Utility Commands</title>

    <itemizedlist>

<!--
Author: Peter Eisentraut <peter@eisentraut.org>
2025-02-07 [83ea6c540] Virtual generated columns
Author: Peter Eisentraut <peter@eisentraut.org>
2025-03-28 [cdc168ad4] Add support for not-null constraints on virtual generate
Author: Richard Guo <rguo@postgresql.org>
2025-02-25 [1e4351af3] Expand virtual generated columns in the planner
-->

<listitem>
<para>
Allow generated columns to be virtual, and make them the default (Peter Eisentraut, Jian He, Richard Guo, Dean Rasheed)
<ulink url="&commit_baseurl;83ea6c540">&sect;</ulink>
<ulink url="&commit_baseurl;cdc168ad4">&sect;</ulink>
<ulink url="&commit_baseurl;1e4351af3">&sect;</ulink>
</para>

<para>
Virtual
Title: PostgreSQL 18: Logical Replication Improvements and Utility Command Updates
Summary
This section details improvements to logical replication in PostgreSQL 18, including the ability to replicate generated column values, changing the default CREATE SUBSCRIPTION streaming option to "parallel", allowing ALTER SUBSCRIPTION to change the replication slot's two-phase commit behavior, and logging conflicts during logical replication. Additionally, it covers utility command updates, specifically allowing generated columns to be virtual, and making them the default.