Tom Lane wrote:
Richard Huxton <dev@xxxxxxxxxxxx> writes:
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.
Let's suppose pg_dump did that, so "pg_dump foo >foo.dump" includes
commands like
ALTER DATABASE foo SET ...
Now what happens when you try to load the script in database bar?
Nothing very good ...
Which would point to the need to allow "ALTER DATABASE
current_database()" or similar I'd say.
--
Richard Huxton
Archonet Ltd
