change all timestamp without time zone columns to timestamp with time zone. Verify that existing data within those columns gets correctly handled. I did an ad hoc test of creating a table with 'timestamp without time zone' and populated it. Then I altered the table and changed the column type to 'timestamp with time zone'. The existing data was automatically converted to PST (-8) or PDT (-7) correctly. We want to ensure that is the behavior that we get when we convert our Socorro data.
broken out all steps required for this bug into separate dependant bugs.
All dependencies completed. QA: examine dependant bugs for testing notes.
QA verified. Associated dependent bugs verified (comment 2). Automation and manual bfts pass.