pg.ddx.io  pgpartman/pg_partman GitHub issues and pull requests  
help / color / mirror / Atom feed
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.md index 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.

Message-ID: <gh-pgpartman-pg_partman-882@github.com>
Permalink:  ../gh-pgpartman-pg_partman-882@github.com/

 ·  · 


This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox