New Data Type Support for Postgres
Postgres replication adds support for TSTZMULTIRANGE, custom enums, and custom composite (tuple) types.
Postgres is powerful because of its flexibility, but until now, many advanced data types weren't supported in replication tools. That meant teams using features like multiranges or custom composite types had to rework schemas or maintain brittle workarounds - slowing them down.
With this update, Artie removes that limitation. For teams building production-critical systems on Postgres, you can now replicate complex data types with the same reliability as standard ones.
We've added support for:
- TSTZMULTIRANGE (multirange): Added in Postgres 14, this lets you store multiple non-overlapping time intervals in one column - perfect for tracking availability windows without conflicts.
- Custom enums: Define your own set of valid string values, like a controlled list of statuses or product sizes, and replicate them reliably.
- Custom composite (tuple) types: Create structured types that combine multiple fields into one, such as storing an address (city, state, street) in a single column.
Why this matters:
- Supports advanced Postgres use cases without schema redesign
- Eliminates brittle workarounds when using complex data types
- Keeps replication consistent across real-world customer schemas
- Opens the door for more application-specific modeling in Postgres