Datatype mismatch warning in logical replication when creating subscription
BharatDB <bharatdbpg@gmail.com>
From: BharatDB <bharatdbpg@gmail.com>
To: pgsql-bugs@lists.postgresql.org
Date: 2025-03-11T15:02:16Z
Lists: pgsql-bugs
Attachments
- Datatype_mismatch_logicalreplication_.patch (text/x-patch) patch
> > 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