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

From BharatDB
Subject Re: Test mail for pgsql-hackers
Date
Msg-id CAAh00ETfXo7VLXy61oHL_u3vGKeer=HVjQ4GeS2UHiB=nXCbWQ@mail.gmail.com
Whole thread Raw
Responses Re: Test mail for pgsql-hackers
List pgsql-hackers
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!
 
Thanks, Blessy   
Attachment

pgsql-hackers by date:

Previous
From: Junwang Zhao
Date:
Subject: Re: SQL Property Graph Queries (SQL/PGQ)
Next
From: Andy Fan
Date:
Subject: a pool for parallel worker