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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: eshkinkot(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6605: wrong type cast from timestamp to timestamptz
Date: 2012-04-25 21:28:24
Message-ID: 4937.1335389304@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

eshkinkot(at)gmail(dot)com writes:
> set timezone to 'W-SU'; select '2011-03-27 23:00:00'::timestamptz;
> SET
> timestamptz
> ------------------------
> 2011-03-28 02:59:54+04

I've applied a patch for this. Thanks for the report!

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2012-04-25 22:02:41 Re: BUG #6608: SELECT FOR UPDATE not obtaining row exclusive locks in CTEs
Previous Message Ari Entlich 2012-04-25 20:25:11 Re: BUG #6612: Functions can be called inside CHECK statements