Re: Unable to format timestamp with time zone; internal coding error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Graham Leggett <minfrin(at)sharp(dot)fm>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Unable to format timestamp with time zone; internal coding error
Date: 2002-12-20 15:03:19
Message-ID: 15377.1040396599@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Graham Leggett <minfrin(at)sharp(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2002-12-20 15:05:41 Re: Database superuser
Previous Message Masaru Sugawara 2002-12-20 14:29:00 Re: dumping tables in non-public schemas..