Postgres replication supports citext
Homogeneous PostgreSQL replication recognizes citext during table introspection and preserves the type in destination schema changes.
Homogeneous PostgreSQL replication now recognizes the citext type during table introspection instead of rejecting it as unsupported. Artie preserves citext when generating destination schema changes, so case-insensitive text columns pass through merge DDL without being reduced to an incompatible type.
Why this matters
- Replicate tables with
citextcolumns without a schema-inspection failure - Keep the source's native type on the destination rather than using a lossy substitute