PYTHON AND POSTGRES DON'T AGREE ON WHAT “CET” MEANS

Summary from the TLDR Dev newsletter

A timezone accepted by Python broke Mergify's merge-freeze queries because Postgres rejected it, and the investigation uncovered four names that silently differ by an hour in summer. The fix uses one curated timezone list and integration tests that compare both systems, rather than validating against either runtime alone.