British Columbia, Time Zones, and Postgres
Summary
PostgreSQL timezone handling during British Columbia's time change; explains timestamptz behavior, tzdata updates, and dual-column pattern to preserve local intent, with SQL checks and migration guidance.