Preserve tz when converting to jsonb timestamptz

Title

Topic

Bug Fixes

Created

2024-07-10 14:33:55

Last modified

2024-08-11 03:10:16 (1 month, 3 weeks ago)

Latest email

2024-07-30 13:42:14 (2 months ago)

Status

2024-09: Committed

Target version

Authors

David Wheeler (theory)

Reviewers

Zhao Junwang (zhjwpku)Become reviewer

Committer

Andrew Dunstan (adunstan)

Links

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/5119
git checkout commitfest/cf/5119

Emails

jsonpath: Inconsistency of timestamp_tz() Output: First at 2024-07-01 15:02:29 by "David E. Wheeler" <david at justatheory.com>
Latest at 2024-07-30 13:42:14 by "David E. Wheeler" <david at justatheory.com>
Latest attachment (v5-0001-Preserve-tz-when-converting-to-jsonb-timestamptz.patch) at 2024-07-22 17:29:02 from "David E. Wheeler" <david at justatheory.com>
    Attachment (v5-0001-Preserve-tz-when-converting-to-jsonb-timestamptz.patch) at 2024-07-22 17:29:02 from "David E. Wheeler" <david at justatheory.com> (Patch: Yes)
    Attachment (v4-0001-Preserve-tz-when-converting-to-jsonb-timestamptz.patch) at 2024-07-22 07:12:21 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: Yes)
    Attachment (v3-0001-Preserve-tz-when-converting-to-jsonb-timestamptz.patch) at 2024-07-19 14:05:25 from "David E. Wheeler" <david at justatheory.com> (Patch: Yes)
    Attachment (v2-0001-Preserve-tz-when-converting-to-jsonb-timestamptz.patch) at 2024-07-10 15:19:32 from "David E. Wheeler" <david at justatheory.com> (Patch: Yes)
    Attachment (v1-0001-Preserve-tz-when-converting-to-jsonb-timestamptz.patch) at 2024-07-10 14:33:05 from "David E. Wheeler" <david at justatheory.com> (Patch: Yes)

History

When	Who	What
2024-08-11 03:10:16	Zhao Junwang (zhjwpku)	Closed in commitfest 2024-09 with status: Committed
2024-08-11 03:10:16	Zhao Junwang (zhjwpku)	Changed committer to adunstan
2024-07-19 17:58:52	David Wheeler (theory)	Changed authors to David Wheeler (theory)
2024-07-10 14:34:24	David Wheeler (theory)	Changed reviewers to Zhao Junwang (zhjwpku)
2024-07-10 14:34:24	David Wheeler (theory)	Changed targetversion to 17
2024-07-10 14:34:24	David Wheeler (theory)	Changed gitlink to https://github.com/theory/postgres/pull/7
2024-07-10 14:33:56	David Wheeler (theory)	Attached mail thread 7DE080CE-6D8C-4794-9BD1-7D9699172FAB@justatheory.com
2024-07-10 14:33:55	David Wheeler (theory)	Created patch record