Re: search_path when restoring to new db

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Brandon Aiken <BAiken(at)winemantech(dot)com>, SunWuKung <Balazs(dot)Klein(at)t-online(dot)hu>, pgsql-general(at)postgresql(dot)org
Subject: Re: search_path when restoring to new db
Date: 2006-12-12 15:53:33
Message-ID: 3494.1165938813@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard Huxton <dev(at)archonet(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-12-12 16:13:19 Re: Unrecognized time zone name error.
Previous Message Shoaib Mir 2006-12-12 15:51:22 Re: returning parameters from function