Re: ERROR: Unable to format timestamp; internal coding error - Mailing list pgsql-sql

From Tom Lane
Subject Re: ERROR: Unable to format timestamp; internal coding error
Date
Msg-id 3434.1088008232@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: Unable to format timestamp; internal coding error  (Stef <svb@ucs.co.za>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Non-standard function names
Next
From: Josh Berkus
Date:
Subject: Re: feature request ?