BC’s permanent DST shift will break Postgres timestamps
On March 8 2026 BC will stay on Pacific Daylight Time year‑round, making America/Vancouver permanently UTC‑7. Because Postgres timestamptz stores UTC and applies the current tz rules on query, appointments saved before the change will appear an hour off later. Store the intended local time and its zone, or update tzdata, to avoid the bug.