Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group