Re: pg_dump: bug?

Neil Conway <nconway@klamath.dyndns.org> writes:
> Now, is this a bug?

Good question.  I don't think this is the only example of a
non-self-consistent situation that could arise after a series of
ALTER commands; I'm not sure that we can or should try to solve
every one.

However, it does seem that a superuser should be able to create
databases on behalf of users who can't themselves do so.   So
I'd say that we need a "CREATE DATABASE foo WITH OWNER bar" option.
Then pg_dumpall should emit such critters rather than the
circumlocution it uses now.
        regards, tom lane