Re: date out of range for timestamp

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: date out of range for timestamp
Дата
Msg-id
23839.1293591973@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
date out of range for timestamp David Rericha <d.rericha@healthcareoss.com>
Re: date out of range for timestamp Tom Lane <tgl@sss.pgh.pa.us>
Re: date out of range for timestamp Scott Marlowe <scott.marlowe@gmail.com>
David Rericha  writes:
> Thanks, Tom.  That was it.  After I ran analyze on the table, the error
> disappeared.

Yeah, I just duplicated the failure here.  It only happens if the
comparison value falls into the histogram bucket adjoining the
out-of-range value, which is why you didn't see it happen for some
values of the comparison constant.  Doesn't look too hard to fix.

			regards, tom lane
В списке pgsql-admin по дате отправления
От: David Rericha
Дата:
От: David Rericha
Дата:
FAQ