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