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.

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

timezone automatically appended while reading a timestamp with tz value from postgres #595

Open
Tracked by #138
artemklimenko-dev opened this issue Sep 29, 2020 · 1 comment
Labels
s: triage Some tests need to be run to confirm the issue

Comments

@artemklimenko-dev
Copy link

Description

I have upgraded from buffalo 16.5 to buffalo 16.15 and it seems that some module (I assume buffalo-pop) has some breaking changes. I am using postgres to store timestamp with timezone values. Postgres contains values with 0 timezone (+00), however, when I read the value with buffalo, the value gets my timezone (+3) appended to the value. This only started to happen when I did the buffalo 16.15 upgrade. It seems like a bug to me

Steps to Reproduce the Problem

  1. Store a timestamp with a zero timezone in postgres
  2. Read the struct using pop model load (your system time should be in other than the +0 timezone )
    For me, this has happened while executing a test, which works fine with older pop and fizz versions

Expected Behavior

I am expecting the timezone to be the same as in the database.

Actual Behavior

The local timezone of the OS seems to be appended to the resulting value

Info

MacOS X Mojave, Pop version 16.15, used through Buffalo

@zepatrik
Copy link
Contributor

zepatrik commented Oct 8, 2020

See also #591

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
s: triage Some tests need to be run to confirm the issue
Projects
None yet
Development

No branches or pull requests

3 participants