BUG #9472: pg_dumpall fails with "unrecognized node type: 650"

Поиск
Список
Период
Сортировка
От Wilfried.Weiss@nsg.com
Тема BUG #9472: pg_dumpall fails with "unrecognized node type: 650"
Дата
Msg-id 20140307125347.1917.19496@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #9472: pg_dumpall fails with "unrecognized node type: 650"  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      9472
Logged by:          Wilfried Weiss
Email address:      Wilfried.Weiss@nsg.com
PostgreSQL version: 9.2.2
Operating system:   AIX 6.1
Description:

Hi,

when trying to run pg_dumpall it fails with the above mentioned error.

The last lines of the output looks like this:

QUOTE START ------

--
-- Database creation
--

pg_dumpall: query failed: ERROR:  unrecognized node type: 650
pg_dumpall: query was: SELECT datname, coalesce(rolname, (select rolname
from pg_authid where oid=(select datdba from pg_database where
datname='template0'))), pg_encoding_to_char(d.encoding), datcollate,
datctype, datfrozenxid, datistemplate, datacl, datconnlimit, (SELECT spcname
FROM pg_tablespace t WHERE t.oid = d.dattablespace) AS dattablespace FROM
pg_database d LEFT JOIN pg_authid u ON (datdba = u.oid) WHERE datallowconn
ORDER BY 1

QUOTE END ---

What can I do to be able to unload the data again?

Regards Wilfried

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #9464: PANIC with 'failed to re-find shared lock object'
Следующее
От: dylan-pgsql@dylex.net
Дата:
Сообщение: BUG #9457: replace materialized view?