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: (view raw or whole 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


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-2015 The PostgreSQL Global Development Group