[Dbix-class] Postgres timestamp with timezone problem

[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