Re: search_path when restoring to new db - Mailing list pgsql-general

Tom Lane wrote:
> Richard Huxton <dev@archonet.com> 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