[Dbix-class] Postgres timestamp with timezone problem

[Alex Povolotsky]

It was purely my error. Having 5 different times of arrival and 
departure, I've wrote with correct timezone one and tried to get 
annother....


14.08.2017 2:39, John Stoffel пишет:
> Can you reproduce this in a smaller test case you can post by any chance?  And which version of the code are you running and which version of Postgres?  And do you have your TIMEZONE env var set as well by any chance?  More details please!
>
> Sent from my iPhone
>
>> On Aug 8, 2017, at 9:13 AM, Alex Povolotsky <tarkhil at over.ru> wrote:
>>
>> Hello
>>
>> I have a table with timestamp with timezone columns; when I put, say, 2017-08-08 12:25:00+0200, it is stored correctly (select in commandline client or plain DBD::Pg returns '2017-08-08 13:25:00+03', it's fine since I'm in Moscow (UTC+3).
>>
>> However, DBIx::Class::InflateColumn::DateTime ignores timestamp.
>>
>> get_column returns 2017-08-08 12:25:00 +0000, get_inflated_column returns object with floating timezone.
>>
>> What can be wrong?
>>
>> All timestamp fields are described as
>>
>>   { data_type => "timestamp with time zone", is_nullable => 0 },
>>
>> by dbicdump.
>>
>> Alex
>>
>>
>> _______________________________________________
>> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
>> IRC: irc.perl.org#dbix-class
>> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
>> Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
>
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
>