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 6491.1335187362@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #6605: wrong type cast from timestamp to timestamptz  (Jochen Erwied <jochen@pgsql-bugs.erwied.eu>)
List pgsql-bugs
Jochen Erwied <jochen@pgsql-bugs.erwied.eu> writes:
> 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:

I traced though it far enough to find that pg_next_dst_boundary indexes
off the end of an array when the given probe time is exactly the last
DST transition time for the zone.  So what's surprising is not that
it fails weirdly, but that there seem to be numerous machines where
it doesn't (appear to) fail.  The next array slot must chance to have
a sane value in some environments.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Matteo Beccati
Date:
Subject: Errors on CREATE TABLE IF NOT EXISTS
Next
From: suvisor.root@gmail.com
Date:
Subject: BUG #6607: Strange select behavior