Pivotal Greenplum (GPDB) 4.3.x
The analyzedb script fails with part of a table name as the reason.
analyzedb:mdw:gpadmin-[CRITICAL]:-analyzedb failed. (Reason=''XXXX'') exiting...
The analyzedb script fails if there is a table with a " "(blank space) in the name.
Find any tables with spaces in the name:
select n.nspname || '.' || c.relname as name from pg_class c, pg_namespace n where n.oid=c.relnamespace and c.relname like '% %';
Rename the tables to remove the spaces:
ALTER TABLE "<table name>" RENAME TO "newName";