Brandon Aiken wrote:
PostgreSQL is simply very granular about what it lets you dump.
True enough, but I'd think you could make a good argument that dumping a database should dump any ALTER commands that are attached to it.
Users are shared between databases, so I can see it doesn't necessarily make sense to dump them. However, an ALTER DATABASE is meaningless without the database concerned.
-- Richard Huxton Archonet Ltd