Closed Bug 714938 Opened 14 years ago Closed 14 years ago

change database to use timezone aware timestamp columns

Categories

(Socorro :: Database, task)

Product:
Socorro
Component:
Database
Platform:
x86_64
Linux
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
VERIFIED FIXED

People

(Reporter: lars, Assigned: jberkus)

References

Details

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.
Assignee: nobody → josh
broken out all steps required for this bug into separate dependant bugs.
Depends on: 715333, 715335, 715339, 715342, 715343, 715346
All dependencies completed. QA: examine dependant bugs for testing notes.
Status: NEW → RESOLVED
Closed: 14 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.