Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: search_path when restoring to new db
Date
Msg-id 3494.1165938813@sss.pgh.pa.us
Whole thread Raw
In response to Re: search_path when restoring to new db  (Richard Huxton <dev@archonet.com>)
Responses Re: search_path when restoring to new db  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view 
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 ...

            regards, tom lane

pgsql-general by date:

Previous
From: "Shoaib Mir"
Date:
Subject: Re: returning parameters from function
Next
From: "Greg Fairbanks"
Date:
Subject: Running initdb from another process