Tom, Alex--
Thanks for the reply.
pg_dump from version 7.1.2 did indeed give a better error message:
getTableAttrs(): SELECT (for DEFAULT) for attr content_type_id returned 0 tuples.
Expected 1.
Also I tried to reindex the system tables... its a no-go.
xapnet_web=# reindex table pg_attribute;
Andrew Sullivan wrote:
[pg_dump problem]
> If you just type the username and password after that, you'll get the
> output you want. Problem is that you're redirecting all output to a
> file, and that includes the username and password prompts.
>
> In 7.x versions, this appears to be fixed using