Skip to content
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

Replace now() with statement_timestamp() #27

Closed
palkan opened this issue Mar 1, 2017 · 1 comment
Closed

Replace now() with statement_timestamp() #27

palkan opened this issue Mar 1, 2017 · 1 comment
Labels
enhancement help wanted

Comments

@palkan
Copy link
Owner

palkan commented Mar 1, 2017

PostgreSQL now() returns the transaction start time (https://www.postgresql.org/docs/9.6/static/functions-datetime.html). That means all changes within the same transaction have equal timestamps.

We should use statement_timestamp() for more accurate timestamps.
@palkan palkan mentioned this issue Mar 1, 2017
Merged
@palkan
Copy link
Owner Author

palkan commented Mar 3, 2017

Closed by #26

@palkan palkan closed this as completed Mar 3, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement help wanted
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@palkan