pgsql: Improve error message for replication of generated columns.

From: Amit Kapila <akapila(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Improve error message for replication of generated columns.
Date: 2024-11-27 03:51:29
Message-ID: E1tG95N-003hgd-Pc@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Improve error message for replication of generated columns.

Currently, logical replication produces a generic error message when
targeting a subscriber-side table column that is either missing or
generated. The error message can be misleading for generated columns.

This patch introduces a specific error message to clarify the issue when
generated columns are involved.

Author: Shubham Khanna
Reviewed-by: Peter Smith, Vignesh C, Amit Kapila
Discussion: https://postgr.es/m/CAHv8RjJBvYtqU7OAofBizOmQOK2Q8h+w9v2_cQWxT_gO7er3Aw@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/8fcd80258bcf43dab93d877a5de0ce3f4d2bd471

Modified Files
--------------
src/backend/replication/logical/relation.c | 91 ++++++++++++++++++++----------
src/test/subscription/t/011_generated.pl | 42 ++++++++++++++
2 files changed, 103 insertions(+), 30 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2024-11-27 07:23:44 pgsql: Support LIKE with nondeterministic collations
Previous Message Thomas Munro 2024-11-27 03:48:01 pgsql: If a C23 compiler is detected, try asking for C17.