Re: Unable to format timestamp with time zone; internal

Tom Lane wrote:

>>  pg_dump: ERROR:  Unable to format timestamp with time zone; internal
>>coding error
>
>
> AFAICT this error can only appear when trying to display a timestamp
> that's before the start of the Julian day count, 4713 BC ... which the
> system should never have let you enter in the first place.  (In my
> tests, the timestamp input routine rejects such dates.)  Got any idea
> how you got that value in there?

Absolutely no idea. Could vacuuming the database affect it?

Any idea what solution I can use to fix this? We can no longer back up
our database any more, which is a critical problem.

Why is this a fatal error? Is there a way of turning this into a warning
so we can at least get the rest of the data out?

Regards,
Graham
--
-----------------------------------------
minfrin@sharp.fm        "There's a moon
                    over Bourbon Street
                        tonight..."