Postgres Pro
Downloads
Home   >   mailing lists

Re: Unable to format timestamp with time zone; internal coding error - Mailing list pgsql-general

From Tom Lane
Subject Re: Unable to format timestamp with time zone; internal coding error
Date
Msg-id 15377.1040396599@sss.pgh.pa.us
Whole thread Raw
In response to Unable to format timestamp with time zone; internal coding error  (Graham Leggett <minfrin@sharp.fm>)
Responses Re: Unable to format timestamp with time zone; internal  (Graham Leggett <minfrin@sharp.fm>)
Re: Unable to format timestamp with time zone; internal  (Graham Leggett <minfrin@sharp.fm>)
List pgsql-general
Tree view 
Graham Leggett <minfrin@sharp.fm> writes:
>   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?

            regards, tom lane

pgsql-general by date:

Previous
From: Vegard Munthe
Date:
Subject: Problems with lower('Å')
Next
From: Oliver Elphick
Date:
Subject: Re: Database superuser