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

From Graham Leggett
Subject Unable to format timestamp with time zone; internal coding error
Date
Msg-id 3E02C69A.5020109@sharp.fm
Whole thread Raw
Responses Re: Unable to format timestamp with time zone; internal coding error  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@sharp.fm        "There's a moon
                    over Bourbon Street
                        tonight..."


pgsql-general by date:

Previous
From: Luke Van
Date:
Subject: no more messages
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: Replacement for Oracle's "ROWNUM" in Postgres