Skip to content

Convert pgroll.migrations created_at and updated_at fields to use timestamptz type #758

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Merged
merged 1 commit into from
Mar 27, 2025
Merged

Convert pgroll.migrations created_at and updated_at fields to use timestamptz type #758

merged 1 commit into from
Mar 27, 2025

Conversation

andrew-farries
Copy link
Collaborator

Change pkg/state/init.sql to update the timestamp columns in the placeholder.migrations table.

The change ensures that the created_at and updated_at columns use the timestamptz data type.

timestamptz is preferred for storing timestamp data for our use case. See eg here.

Fixes #711

@github-actions github-actions bot temporarily deployed to Docs Preview March 27, 2025 07:08 Inactive
@andrew-farries andrew-farries marked this pull request as ready for review March 27, 2025 09:37
@andrew-farries andrew-farries requested a review from kvch March 27, 2025 09:38
@andrew-farries andrew-farries merged commit 9ded2f9 into main Mar 27, 2025
30 checks passed
@andrew-farries andrew-farries deleted the convert-timestamps-to-utc branch March 27, 2025 11:15
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers

@kvch kvch kvch approved these changes

Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.

Use timestamp with timezone for created_at, updated_at in migrations table
2 participants
@andrew-farries @kvch