Unable to format timestamp with time zone; internal coding error

Поиск
Список
Период
Сортировка
Искать
От
Graham Leggett
Тема
Unable to format timestamp with time zone; internal coding error
Дата
Msg-id
3E02C69A.5020109@sharp.fm
Список
Дерево обсуждения
Unable to format timestamp with time zone; internal coding error Graham Leggett <minfrin@sharp.fm>
Re: Unable to format timestamp with time zone; internal coding error Tom Lane <tgl@sss.pgh.pa.us>
Re: Unable to format timestamp with time zone; internal Graham Leggett <minfrin@sharp.fm>
Re: Unable to format timestamp with time zone; internal coding error Tom Lane <tgl@sss.pgh.pa.us>
Re: Unable to format timestamp with time zone; internal Graham Leggett <minfrin@sharp.fm>
Re: Unable to format timestamp with time zone; Lincoln Yeoh <lyeoh@pop.jaring.my>
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 по дате отправления
От: Luke Van
Дата:
Сообщение: no more messages
От: Shridhar Daithankar
Дата:
FAQ