Re: [BUGS] BUG #6605: wrong type cast from timestamp to timestamptz

2012-04-22 Thread Jochen Erwied
Saturday, April 21, 2012, 7:49:55 PM you wrote: > So: some platform-specific misbehavior here. I have no time to poke at > it more now, though. Who else can reproduce this, on what platforms? One machine works, the other not: PostgreSQL 9.1.3 on i686-pc-linux-gnu, compiled by i686-pc-linux-gnu

Re: [BUGS] BUG #6605: wrong type cast from timestamp to timestamptz

2012-04-22 Thread Kevin Grittner
> Tom Lane wrote: > eshkin...@gmail.com writes: >> set timezone to 'W-SU'; select '2011-03-27 23:00:00'::timestamptz; >> SET >> timestamptz >> >> 2011-03-28 02:59:54+04 > > Bizarre. On my Fedora 16 box, I see a different misbehavior: > > regression=# set timezone to 'Eur