pg.ddx.io  pgpartman/pg_partman GitHub issues and pull requests  
help / color / mirror / Atom feed
From: AlexeyShalaev (@AlexeyShalaev) <noreply+AlexeyShalaev@github.com>
To: pgpartman/pg_partman <noreply+pgpartman-pg_partman@github.com>
Subject: Re: [pgpartman/pg_partman] PR #879: fix: partition_data_time() compares the control column in its own type
Date: Sat, 24 Oct 2026 10:17:25 +0000
Message-ID: <gh-pgpartman-pg_partman-879-c6383005810@github.com> (raw)
In-Reply-To: <gh-pgpartman-pg_partman-879@github.com>
References: <gh-pgpartman-pg_partman-879@github.com>

Thanks for merging! I think that run used the 5.5.0 functions that were already in the database. The error is exactly what the old text comparison produces: I get the same message, down to `p20260701` and the `-04` bounds, by installing v5.5.0, creating the extension, and then running the new test from 551 with `PGTZ=America/New_York`.

On 551 the control file still says 5.5.0, so `make install` puts the new code on disk, but an existing 5.5.0 install keeps its old functions until it's updated. After `ALTER EXTENSION pg_partman UPDATE TO '5.5.1';` the same test passes, 12/12. A fresh `CREATE EXTENSION` from 551 passes too. I ran that under UTC, America/New_York and Asia/Tokyo (PG 17) to rule out a timezone problem.

If it still fails for you after the update, send me the output of `SELECT extversion FROM pg_extension WHERE extname = 'pg_partman';` and your PG version, and I'll dig further.

view thread (12+ messages)  latest in thread

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