Re: date out of range for timestamp - Mailing list pgsql-admin

From Tom Lane
Subject Re: date out of range for timestamp
Date
Msg-id 23839.1293591973@sss.pgh.pa.us
Whole thread Raw
In response to Re: date out of range for timestamp  (David Rericha <d.rericha@healthcareoss.com>)
Responses Re: date out of range for timestamp
List pgsql-admin
David Rericha <d.rericha@healthcareoss.com> 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 by date:

Previous
From: David Rericha
Date:
Subject: Re: date out of range for timestamp
Next
From: David Rericha
Date:
Subject: Re: date out of range for timestamp