Re: date out of range for timestamp

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Rericha <d(dot)rericha(at)healthcareoss(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: date out of range for timestamp
Date: 2010-12-29 03:06:13
Message-ID: 23839.1293591973@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

David Rericha <d(dot)rericha(at)healthcareoss(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Achilleas Mantzios 2010-12-29 14:06:41 SET SESSION AUTHORIZATION and log file entries
Previous Message David Rericha 2010-12-29 03:01:51 Re: date out of range for timestamp