pg.ddx.io  pgpartman/pg_partman GitHub issues and pull requests  
help / color / mirror / Atom feed
From: miguelaristy (@miguelaristy) <noreply+miguelaristy@github.com>
To: pgpartman/pg_partman <noreply+pgpartman-pg_partman@github.com>
Subject: Re: [pgpartman/pg_partman] issue #862: Invalid format call in partition_data_time
Date: Fri, 10 Jul 2026 22:11:52 +0000
Message-ID: <gh-pgpartman-pg_partman-862-c4939936544@github.com> (raw)
In-Reply-To: <gh-pgpartman-pg_partman-862@github.com>
References: <gh-pgpartman-pg_partman-862@github.com>

Confirming this on pg_partman 5.3.1 as well. Ran into the exact same error
while migrating data out of the default partition via `partition_data_proc()`
on a monthly time-based partition set.

The fix suggested in the issue is correct — since `v_column_list` was removed
as the first argument, the explicit positional references need to shift by one:

```sql
-- Before (broken):
'SELECT * FROM ONLY %I.%I WHERE %s >= %L AND %4$s < %6$L FOR UPDATE NOWAIT'

-- After (fixed):
'SELECT * FROM ONLY %I.%I WHERE %s >= %L AND %3$s < %5$L FOR UPDATE NOWAIT'
```

One extra note for anyone on a managed service: in my case (Azure Database
for PostgreSQL Flexible Server), the extension's functions are owned by the
platform's internal superuser role, not by the admin account — so
`CREATE OR REPLACE FUNCTION` to apply this patch locally fails with
`must be owner of function`. This means users on managed platforms (Azure,
RDS, Cloud SQL, etc.) can't self-patch and have to wait for the platform
provider to certify a newer pg_partman version, or work around it by moving
default-partition data manually without going through `partition_data_time()`.

Is there a recommended way for managed-service users to flag this kind of
fix as high-priority so it gets picked up faster in the next patch release?
Or any pointer on how best to escalate this to platform providers (Azure,
AWS, GCP) so they prioritize certifying the fixed version?

view thread (4+ messages)  latest in thread

Message-ID: <gh-pgpartman-pg_partman-862-c4939936544@github.com>
Permalink:  ../gh-pgpartman-pg_partman-862-c4939936544@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