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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #6605: wrong type cast from timestamp to timestamptz
Дата
Msg-id 6491.1335187362@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #6605: wrong type cast from timestamp to timestamptz  (Jochen Erwied <jochen@pgsql-bugs.erwied.eu>)
Список 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 по дате отправления:

Предыдущее
От: Matteo Beccati
Дата:
Сообщение: Errors on CREATE TABLE IF NOT EXISTS
Следующее
От: suvisor.root@gmail.com
Дата:
Сообщение: BUG #6607: Strange select behavior