Horton

Improve error message for replication of generated columns.

Amit Kapila <akapila@postgresql.org>

View on postgr.es
Commit: 8fcd80258bcf43dab93d877a5de0ce3f4d2bd471
Author: Amit Kapila <akapila@postgresql.org>
Date: 2024-11-27T03:39:20Z
Releases: 18.0 
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

Files

PathChange+/−
src/backend/replication/logical/relation.c modified +61 −30
src/test/subscription/t/011_generated.pl modified +42 −0

Discussion