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-22 16:37:27
Message-ID: 25474.1040575047@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:
> Any idea what solution I can use to fix this?

Find the row (or rows) containing the bad value, and delete or update
it/them. It's possible that this is just one symptom of a data
corruption problem, so you probably should take a close look at the
other fields of the bad rows while you are at it.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lincoln Yeoh 2002-12-22 16:44:10 Re: Unable to format timestamp with time zone;
Previous Message Graham Leggett 2002-12-22 14:26:57 Re: Unable to format timestamp with time zone; internal