Re: Test mail for pgsql-hackers - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Test mail for pgsql-hackers
Date
Msg-id CAKFQuwY2YppzALVMdwUAsQv=Ht4U9=3LBfAMiwTYLSFoke7wrw@mail.gmail.com
Whole thread Raw
In response to Re: Test mail for pgsql-hackers  (Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>)
List pgsql-hackers
On Wednesday, March 12, 2025, Ashutosh Bapat <ashutosh.bapat.oss@gmail.com> wrote:
Hi Blessy,

On Tue, Mar 11, 2025 at 6:03 PM BharatDB <bharatdbpg@gmail.com> wrote:
>>
>> Hi ,
>
>
>>
>> I’ve been exploring logical replication and noticed that if the column datatypes don’t match between the publisher and subscriber, PostgreSQL doesn’t give a warning. This can cause unexpected behavior, and I thought it might be helpful to alert users when this happens.
>
>
>>
>> ### **What This Patch Does:**
>
>
>>
>> - Adds a warning when a column's datatype in the subscriber doesn’t match the publisher.
>>
>> - Helps users catch issues early instead of running into silent errors later.
>
>
>>
>> Why I Think It’s Useful:- Avoids confusion when replication doesn’t work as expected. - Makes debugging easier by pointing out potential problems. I’d love to get feedback on whether this is a good idea and if I’ve approached it correctly. Since I’m still learning, any suggestions for improvement would be really helpful. I’ve attached the patch—please let me know what you think!

Large part of your patch is renaming files which are not related to
this patch. Can you please clean that up.

If there is really a patch submission happening here I suggest you start a new thread with a meaningful subject line and proper recipients (one list, not -owners)

David J.
 

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: Question about duplicate JSONTYPE_JSON check
Next
From: Tomas Vondra
Date:
Subject: Re: Changing the state of data checksums in a running cluster