pg_partman icon indicating copy to clipboard operation
pg_partman copied to clipboard

Feature: add support for text and uuid type control columns

Open akulapid opened this issue 6 months ago • 6 comments

This change introduces two new parameters on create_parent, a pair of encoder/decoder functions that users can define to describe how a text/uuid column maps to time information. Once we derive time from the column, we can leverage existing time partitioning logic to manage partitions for text columns.

Allowing users to define functions brings flexibility to support various formats of identifiers such as UUIDv7, ULID, Snowflake IDs etc. As a convenience, encoder/decoder functions are included for UUIDv7 given the widespread standard.

Issue tracker: https://github.com/pgpartman/pg_partman/issues/528

akulapid avatar Aug 19 '24 15:08 akulapid