Neil Conway <nconway(at)klamath(dot)dyndns(dot)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