Stef <svb@ucs.co.za> writes:
> I've narrowed my problem down to the following
> Java Timestamp that I managed to insert into
> a postgres 7.3.4 database :
> Timestamp : '1475666-11-30 02:00:00.0'
> My problem is, that when I try and select from the table I inserted
> this timestamp into, I get the following error :
> ERROR: Unable to format timestamp; internal coding error
FWIW, this is fixed in 7.4 and later.
> Is there a way to select the values in the table?
I'd try something likeUPDATE table SET ... WHERE timestamp > '9999-01-01';
regards, tom lane