Re: Pgoutput not capturing the generated columns

From: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
To: Ajin Cherian <itsajin(at)gmail(dot)com>
Cc: Peter Smith <smithpb2250(at)gmail(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, Shubham Khanna <khannashubham1197(at)gmail(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Rajendra Kumar Dangwal <dangwalrajendra888(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org, euler(at)eulerto(dot)com
Subject: Re: Pgoutput not capturing the generated columns
Date: 2024-11-04 03:20:26
Message-ID: CAA4eK1LqF81cXuc-EFzBhaJAVHC4_zURYs3isdA9PnZVAGLNiQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Oct 31, 2024 at 4:26 PM Ajin Cherian <itsajin(at)gmail(dot)com> wrote:
>
> 5. Verified that publications with different column list are disallowed to be subscribed by one subscription
> a. PUB_A(column list = (a, b)) PUB_B(no column list, with publish_generated_column) - OK
> b. PUB_A(column list = (a, b)) PUB_B(no column list, without publish_generated_column) - FAIL
> c. PUB_A(no column list, without publish_generated_column) PUB_B(no column list, with publish_generated_column) - FAIL
>
> Tests did not show any unexpected behaviour.
>

Thanks for the tests, but the results of step 5 do not clearly show
whether they are correct because you haven't shared the table schema.

--
With Regards,
Amit Kapila.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message jian he 2024-11-04 03:27:49 Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different.
Previous Message Peter Smith 2024-11-04 02:12:48 Re: Pgoutput not capturing the generated columns