Thread: ERROR: Unable to format timestamp; internal coding error

Hi all,

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

OR if I try converting it :

=# select date(hpacc_cancelled) from hp_acc;
ERROR:  Unable to convert timestamp to date
=# select to_char(hpacc_cancelled,'YYYY') from hp_acc where hpacc_cancelled is not null;
ERROR:  to_char(): Unable to convert timestamp to tm

Is there any way I can isolate these and fix them on the database ?
Is there a way to select the values in the table?

Kind Regards
Stefan

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