pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Run regression tests with timezone America/Los_Angeles. 7+ messages / 1 participants [nested] [flat]
* pgsql: Run regression tests with timezone America/Los_Angeles. @ 2024-09-14 21:55 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 7+ messages in thread From: Tom Lane @ 2024-09-14 21:55 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Run regression tests with timezone America/Los_Angeles. Historically we've used timezone "PST8PDT", but the recent release 2024b of tzdb changes the definition of that zone in a way that breaks many test cases concerned with dates before 1970. Although we've not yet adopted 2024b into our own tree, this is already problematic for people using --with-system-tzdata if their platform has already adopted 2024b. To work with both older and newer versions of tzdb, switch to using "America/Los_Angeles", accepting the ensuing changes in regression test results. Back-patch to all supported branches. Per report and patch from Wolfgang Walther. Discussion: https://postgr.es/m/0a997455-5aba-4cf2-a354-d26d8bcbfae6@technowledgy.de Branch ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/2b94ee58bf256e1b4682f21f13d0f2c73e1b0cc2 Modified Files -------------- doc/src/sgml/ref/set.sgml | 4 +- doc/src/sgml/regress.sgml | 6 +- src/test/regress/expected/date.out | 10 +-- src/test/regress/expected/horology.out | 57 +++++++------ src/test/regress/expected/timestamptz.out | 137 ++++++++++++++++-------------- src/test/regress/pg_regress.c | 2 +- src/test/regress/sql/horology.sql | 4 +- src/test/regress/sql/timestamptz.sql | 5 +- 8 files changed, 120 insertions(+), 105 deletions(-) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Run regression tests with timezone America/Los_Angeles. @ 2024-09-14 21:55 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 7+ messages in thread From: Tom Lane @ 2024-09-14 21:55 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Run regression tests with timezone America/Los_Angeles. Historically we've used timezone "PST8PDT", but the recent release 2024b of tzdb changes the definition of that zone in a way that breaks many test cases concerned with dates before 1970. Although we've not yet adopted 2024b into our own tree, this is already problematic for people using --with-system-tzdata if their platform has already adopted 2024b. To work with both older and newer versions of tzdb, switch to using "America/Los_Angeles", accepting the ensuing changes in regression test results. Back-patch to all supported branches. Per report and patch from Wolfgang Walther. Discussion: https://postgr.es/m/0a997455-5aba-4cf2-a354-d26d8bcbfae6@technowledgy.de Branch ------ REL_17_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/6283ff2018e3dfa74e5b41cceba0642a6b53ca39 Modified Files -------------- doc/src/sgml/ref/set.sgml | 4 +- doc/src/sgml/regress.sgml | 6 +- src/test/regress/expected/date.out | 10 +-- src/test/regress/expected/horology.out | 48 +++++------ src/test/regress/expected/timestamptz.out | 137 ++++++++++++++++-------------- src/test/regress/pg_regress.c | 2 +- src/test/regress/sql/timestamptz.sql | 5 +- 7 files changed, 111 insertions(+), 101 deletions(-) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Run regression tests with timezone America/Los_Angeles. @ 2024-09-14 21:55 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 7+ messages in thread From: Tom Lane @ 2024-09-14 21:55 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Run regression tests with timezone America/Los_Angeles. Historically we've used timezone "PST8PDT", but the recent release 2024b of tzdb changes the definition of that zone in a way that breaks many test cases concerned with dates before 1970. Although we've not yet adopted 2024b into our own tree, this is already problematic for people using --with-system-tzdata if their platform has already adopted 2024b. To work with both older and newer versions of tzdb, switch to using "America/Los_Angeles", accepting the ensuing changes in regression test results. Back-patch to all supported branches. Per report and patch from Wolfgang Walther. Discussion: https://postgr.es/m/0a997455-5aba-4cf2-a354-d26d8bcbfae6@technowledgy.de Branch ------ REL_13_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/b28b9b19bbe3410da4a805ef775e0383a66af314 Modified Files -------------- doc/src/sgml/ref/set.sgml | 4 +- doc/src/sgml/regress.sgml | 6 +- src/test/regress/expected/date.out | 10 +- src/test/regress/expected/horology.out | 57 +++---- src/test/regress/expected/timestamptz.out | 249 +++++++++++++++--------------- src/test/regress/pg_regress.c | 2 +- src/test/regress/sql/horology.sql | 4 +- src/test/regress/sql/timestamptz.sql | 5 +- 8 files changed, 176 insertions(+), 161 deletions(-) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Run regression tests with timezone America/Los_Angeles. @ 2024-09-14 21:55 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 7+ messages in thread From: Tom Lane @ 2024-09-14 21:55 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Run regression tests with timezone America/Los_Angeles. Historically we've used timezone "PST8PDT", but the recent release 2024b of tzdb changes the definition of that zone in a way that breaks many test cases concerned with dates before 1970. Although we've not yet adopted 2024b into our own tree, this is already problematic for people using --with-system-tzdata if their platform has already adopted 2024b. To work with both older and newer versions of tzdb, switch to using "America/Los_Angeles", accepting the ensuing changes in regression test results. Back-patch to all supported branches. Per report and patch from Wolfgang Walther. Discussion: https://postgr.es/m/0a997455-5aba-4cf2-a354-d26d8bcbfae6@technowledgy.de Branch ------ REL_16_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/2abc88958039990ba82669aa9beebd394d06e9a2 Modified Files -------------- doc/src/sgml/ref/set.sgml | 4 +- doc/src/sgml/regress.sgml | 6 +- src/test/regress/expected/date.out | 10 +-- src/test/regress/expected/horology.out | 57 +++++++------ src/test/regress/expected/timestamptz.out | 137 ++++++++++++++++-------------- src/test/regress/pg_regress.c | 2 +- src/test/regress/sql/horology.sql | 4 +- src/test/regress/sql/timestamptz.sql | 5 +- 8 files changed, 120 insertions(+), 105 deletions(-) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Run regression tests with timezone America/Los_Angeles. @ 2024-09-14 21:55 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 7+ messages in thread From: Tom Lane @ 2024-09-14 21:55 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Run regression tests with timezone America/Los_Angeles. Historically we've used timezone "PST8PDT", but the recent release 2024b of tzdb changes the definition of that zone in a way that breaks many test cases concerned with dates before 1970. Although we've not yet adopted 2024b into our own tree, this is already problematic for people using --with-system-tzdata if their platform has already adopted 2024b. To work with both older and newer versions of tzdb, switch to using "America/Los_Angeles", accepting the ensuing changes in regression test results. Back-patch to all supported branches. Per report and patch from Wolfgang Walther. Discussion: https://postgr.es/m/0a997455-5aba-4cf2-a354-d26d8bcbfae6@technowledgy.de Branch ------ REL_12_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/205813da4c264d80db3c3215db199cc119e18369 Modified Files -------------- doc/src/sgml/ref/set.sgml | 4 +- doc/src/sgml/regress.sgml | 6 +- src/test/regress/expected/date.out | 10 +- src/test/regress/expected/horology.out | 53 ++++--- src/test/regress/expected/timestamptz.out | 249 +++++++++++++++--------------- src/test/regress/pg_regress.c | 2 +- src/test/regress/sql/horology.sql | 4 +- src/test/regress/sql/timestamptz.sql | 5 +- 8 files changed, 178 insertions(+), 155 deletions(-) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Run regression tests with timezone America/Los_Angeles. @ 2024-09-14 21:55 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 7+ messages in thread From: Tom Lane @ 2024-09-14 21:55 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Run regression tests with timezone America/Los_Angeles. Historically we've used timezone "PST8PDT", but the recent release 2024b of tzdb changes the definition of that zone in a way that breaks many test cases concerned with dates before 1970. Although we've not yet adopted 2024b into our own tree, this is already problematic for people using --with-system-tzdata if their platform has already adopted 2024b. To work with both older and newer versions of tzdb, switch to using "America/Los_Angeles", accepting the ensuing changes in regression test results. Back-patch to all supported branches. Per report and patch from Wolfgang Walther. Discussion: https://postgr.es/m/0a997455-5aba-4cf2-a354-d26d8bcbfae6@technowledgy.de Branch ------ REL_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/b27622c90869aab63cfe22159a459c57768b0fa4 Modified Files -------------- doc/src/sgml/ref/set.sgml | 4 +- doc/src/sgml/regress.sgml | 6 +- src/test/regress/expected/date.out | 10 +-- src/test/regress/expected/horology.out | 57 +++++++------ src/test/regress/expected/timestamptz.out | 137 ++++++++++++++++-------------- src/test/regress/pg_regress.c | 2 +- src/test/regress/sql/horology.sql | 4 +- src/test/regress/sql/timestamptz.sql | 5 +- 8 files changed, 120 insertions(+), 105 deletions(-) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Run regression tests with timezone America/Los_Angeles. @ 2024-09-14 21:55 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 7+ messages in thread From: Tom Lane @ 2024-09-14 21:55 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Run regression tests with timezone America/Los_Angeles. Historically we've used timezone "PST8PDT", but the recent release 2024b of tzdb changes the definition of that zone in a way that breaks many test cases concerned with dates before 1970. Although we've not yet adopted 2024b into our own tree, this is already problematic for people using --with-system-tzdata if their platform has already adopted 2024b. To work with both older and newer versions of tzdb, switch to using "America/Los_Angeles", accepting the ensuing changes in regression test results. Back-patch to all supported branches. Per report and patch from Wolfgang Walther. Discussion: https://postgr.es/m/0a997455-5aba-4cf2-a354-d26d8bcbfae6@technowledgy.de Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/b8ea0f675f35c3f0c2cf62175517ba0dacad4abd Modified Files -------------- doc/src/sgml/ref/set.sgml | 4 +- doc/src/sgml/regress.sgml | 6 +- src/test/regress/expected/date.out | 10 +-- src/test/regress/expected/horology.out | 48 +++++------ src/test/regress/expected/timestamptz.out | 137 ++++++++++++++++-------------- src/test/regress/pg_regress.c | 2 +- src/test/regress/sql/timestamptz.sql | 5 +- 7 files changed, 111 insertions(+), 101 deletions(-) ^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2024-09-14 21:55 UTC | newest] Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-09-14 21:55 pgsql: Run regression tests with timezone America/Los_Angeles. Tom Lane <tgl@sss.pgh.pa.us> 2024-09-14 21:55 pgsql: Run regression tests with timezone America/Los_Angeles. Tom Lane <tgl@sss.pgh.pa.us> 2024-09-14 21:55 pgsql: Run regression tests with timezone America/Los_Angeles. Tom Lane <tgl@sss.pgh.pa.us> 2024-09-14 21:55 pgsql: Run regression tests with timezone America/Los_Angeles. Tom Lane <tgl@sss.pgh.pa.us> 2024-09-14 21:55 pgsql: Run regression tests with timezone America/Los_Angeles. Tom Lane <tgl@sss.pgh.pa.us> 2024-09-14 21:55 pgsql: Run regression tests with timezone America/Los_Angeles. Tom Lane <tgl@sss.pgh.pa.us> 2024-09-14 21:55 pgsql: Run regression tests with timezone America/Los_Angeles. Tom Lane <tgl@sss.pgh.pa.us>
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