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

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stef <svb(at)ucs(dot)co(dot)za>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: ERROR: Unable to format timestamp; internal coding error
Date: 2004-06-23 16:30:32
Message-ID: 3434.1088008232@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-sql
Stef <svb(at)ucs(dot)co(dot)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 like
	UPDATE table SET ... WHERE timestamp > '9999-01-01';

			regards, tom lane

In response to

pgsql-sql by date

Next:From: Josh BerkusDate: 2004-06-23 17:12:36
Subject: Re: feature request ?
Previous:From: Tom LaneDate: 2004-06-23 16:26:46
Subject: Re: Non-standard function names

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