pg.ddx.io  pgpartman/pg_partman GitHub issues and pull requests  
help / color / mirror / Atom feed
From: ritojoao (@ritojoao) <noreply+ritojoao@github.com>
To: pgpartman/pg_partman <noreply+pgpartman-pg_partman@github.com>
Subject: Re: [pgpartman/pg_partman] PR #887: Compare partition_data_time() bounds as timestamptz, not text
Date: Tue, 10 Nov 2026 15:55:55 +0000
Message-ID: <gh-pgpartman-pg_partman-887-c6772138730@github.com> (raw)
In-Reply-To: <gh-pgpartman-pg_partman-887@github.com>
References: <gh-pgpartman-pg_partman-887@github.com>

Thanks for checking! You're right. I built the #883 branch and ran it on PostgreSQL 17:

- The repro script from #868 now puts all three rows in the right child tables, with the session time zone set to UTC and to America/Sao_Paulo.
- The test from this PR (date and timestamp control columns, `timezone = 'America/New_York'`) passes on #883 without any other change, and so does the rest of the top-level test suite.

Since #883 makes the same change, I'll close this PR. The only extra thing here is that the test runs in a non-UTC time zone. If you think that's useful, I'm happy to open a small PR with just that test after 5.5.1 is merged. Sorry I missed #856!


view thread (5+ messages)  latest in thread

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