Re: Pgoutput not capturing the generated columns

On Tue, 29 Oct 2024 at 17:09, Shubham Khanna
<khannashubham1197(at)gmail(dot)com> wrote:
>
> While performing the Backward Compatibility Test, I found that
> 'tablesync' is not working for the older versions i.e., from
> version-12 till version-15.
> I created 2 nodes ; PUBLISHER on old versions and SUBSCRIBER on HEAD +
> v45 Patch for testing.
> Following was done on the PUBLISHER node:
> CREATE TABLE t1 (c1 int, c2 int GENERATED ALWAYS AS (c1 * 2) STORED);
> INSERT INTO t1 (c1) VALUES (1), (2);
> CREATE PUBLICATION pub1 for table t1;
>
> Following was done on the SUBSCRIBER node:
> CREATE TABLE t1 (c1 int, c2 int);
> CREATE SUBSCRIPTION sub1 CONNECTION 'dbname=postgres' PUBLICATION pub1;
>
> Following Error occurs repeatedly in the Subscriber log files:
> ERROR: could not start initial contents copy for table "public.t1":
> ERROR: column "c2" is a generated column
> DETAIL: Generated columns cannot be used in COPY.

Thank you for reporting this issue. The attached v46 patch addresses
the problem and includes some adjustments to the comments. Thanks to
Amit for sharing the comment changes offline.

Regards,
Vignesh