Datatype mismatch warning in logical replication when creating subscription

From: BharatDB <bharatdbpg(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Datatype mismatch warning in logical replication when creating subscription
Date: 2025-03-11 15:02:16
Message-ID: CAAh00EQmhG8VzcBhdmH4nnavh25kj_SFyOwAf_NoKyV2JEtXPg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

>
> 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 Content-Type Size
Datatype_mismatch_logicalreplication_.patch text/x-patch 48.3 KB

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2025-03-11 17:14:31 Re: Attribute of type record has wrong type error with MERGE ... WHEN NOT MATCHED BY SOURCE THEN DELETE
Previous Message Laurenz Albe 2025-03-11 12:44:55 Re: BUG #18833: libpq.so doesn't contain declared symbol in rpm --provides