From: yababaina (@yababaina) <noreply+yababaina@github.com>
To: pgpartman/pg_partman <noreply+pgpartman-pg_partman@github.com>
Subject: [pgpartman/pg_partman] PR #882: doc: add text/uuid control and time_encoder/time_decoder to part_config
Date: Fri, 16 Oct 2026 05:42:51 +0000
Message-ID: <gh-pgpartman-pg_partman-882@github.com> (raw)
The `part_config` docs still say `control` must be a time or integer column, but text/uuid control columns have been supported since 5.2.0 ([create_partition.sql][1]), and `time_encoder`/`time_decoder` are stored in `part_config` ([tables.sql][2]) and used by maintenance ([run_maintenance.sql][3]). This updates the `control` description and adds the two columns to the `part_config` docs.
Thank you for the great extension!
[1]: https://github.com/pgpartman/pg_partman/blob/c737cc1d32a46a37120aa691f7dd0bce6ad07660/sql/functions/...
[2]: https://github.com/pgpartman/pg_partman/blob/c737cc1d32a46a37120aa691f7dd0bce6ad07660/sql/tables/tab...
[3]: https://github.com/pgpartman/pg_partman/blob/c737cc1d32a46a37120aa691f7dd0bce6ad07660/sql/functions/...inline patch 1: doc/pg_partman.md (+7/-1 lines) download inline-1.patchdiff --git a/doc/pg_partman.md b/doc/pg_partman.mdindex 03405e3..7b5dd4d 100644--- a/doc/pg_partman.md+++ b/doc/pg_partman.md@@ -817,6 +817,8 @@ Stores all configuration data for partition sets managed by the extension.
parent_table text NOT NULL
, control text NOT NULL
+ , time_encoder text+ , time_decoder text
, partition_interval text NOT NULL
, partition_type text NOT NULL
, premake int NOT NULL DEFAULT 4
@@ -845,7 +847,11 @@ Stores all configuration data for partition sets managed by the extension.
- `parent_table`
- Parent table of the partition set
- `control`
- - Column used as the control for partition constraints. Must be a time or integer based column.+ - Column used as the control for partition constraints. Must be a time, integer, text or uuid based column. When control is of type text/uuid, `time_encoder` and `time_decoder` must be set.+ - `time_encoder`+ - Name of the function that encodes a timestamp into a control column value. See `p_time_encoder` in `create_partition()` for when it is required.+ - `time_decoder`+ - Name of the function that decodes a control column value into a timestamp. See `p_time_decoder` in `create_partition()` for when it is required.
- `partition_interval`
- Text type value that determines the interval for each partition.
- Must be a value that can either be cast to the interval or bigint data types.