Unable to format timestamp with time zone; internal coding error

From: Graham Leggett <minfrin(at)sharp(dot)fm>
To: pgsql-general(at)postgresql(dot)org
Subject: Unable to format timestamp with time zone; internal coding error
Date: 2002-12-20 07:28:26
Message-ID: 3E02C69A.5020109@sharp.fm
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

We have suddenly encountered a problem with a v7.2.1 database
pg_dumpall. The output looks as follows:

connected to template1...
dumping database "cws"...
pg_dump: ERROR: Unable to format timestamp with time zone; internal
coding error
pg_dump: lost synchronization with server, resetting connection
pg_dump: SQL command to dump the contents of table "alr_bpc_list"
failed: PQendcopy() failed.
pg_dump: Error message from server: pg_dump: The command was: COPY
"alr_bpc_list" TO stdout;
pg_dump failed on cws, exiting

Searching the lists shows mention of this error in early feb as a bug.
One option for us is to upgrade to v7.3 - but to do this we need to dump
the database, and this is failing.

Does anyone have a patch for this bug we can apply to v7.2.1?

Can anyone explain further what this bug means?

Regards,
Graham
--
-----------------------------------------
minfrin(at)sharp(dot)fm "There's a moon
over Bourbon Street
tonight..."

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2002-12-20 07:31:58 Re: Replacement for Oracle's "ROWNUM" in Postgres
Previous Message Rajesh Kumar Mallah. 2002-12-20 06:30:47 dumping tables in non-public schemas..