Would you alter this timestamp type?

Situation

A migration standardizes all timestamp columns to TIMESTAMPTZ for timezone safety.

Environment

Production PostgreSQL with a large events table and heavy write traffic.

Select suspicious lines in the terminal to flag them before submitting your verdict.

pending review

-- migrate_timestamp_storage.sql
BEGIN;

SET LOCAL lock_timeout = '60s';

ALTER TABLE events
ALTER COLUMN created_at TYPE TIMESTAMPTZ;

ALTER TABLE events
ALTER COLUMN updated_at TYPE TIMESTAMPTZ;

UPDATE events
SET timezone_offset = EXTRACT(TIMEZONE FROM created_at) / 3600
WHERE timezone_offset IS NULL;

COMMIT;