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!