change database to use timezone aware timestamp columns

VERIFIED FIXED in 2.4

Status

Socorro
Database
VERIFIED FIXED
6 years ago
6 years ago

People

(Reporter: lars, Assigned: jberkus)

Tracking

Dependency tree / graph

Firefox Tracking Flags

(Not tracked)

Details

(Reporter)

Description

6 years ago
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.
(Reporter)

Updated

6 years ago
Assignee: nobody → josh
(Assignee)

Comment 1

6 years ago
broken out all steps required for this bug into separate dependant bugs.
(Assignee)

Comment 2

6 years ago
All dependencies completed.

QA: examine dependant bugs for testing notes.
Status: NEW → RESOLVED
Last Resolved: 6 years ago
Resolution: --- → FIXED
QA verified. Associated dependent bugs verified (comment 2).

Automation and manual bfts pass.
Status: RESOLVED → VERIFIED
You need to log in before you can comment on or make changes to this bug.