Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #6605: wrong type cast from timestamp to timestamptz - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #6605: wrong type cast from timestamp to timestamptz
Date
Msg-id 4937.1335389304@sss.pgh.pa.us
Whole thread Raw
In response to BUG #6605: wrong type cast from timestamp to timestamptz  (eshkinkot@gmail.com)
List pgsql-bugs
Tree view 
eshkinkot@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

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

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #6602: concurrent psql session clobbers history
Next
From: Tom Lane
Date:
Subject: Re: BUG #6608: SELECT FOR UPDATE not obtaining row exclusive locks in CTEs