Re: add_missing_from breaks existing views

On 2005-10-26, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Andrew - Supernews <andrew+nonews(at)supernews(dot)com> writes:
>> Wild idea: how about having pg_dump include SET add_missing_from = true;
>> in the dump file if, and only if, it is set that way in the server?
>
> Uh, no ... the global setting of add_missing_from does *not* tell you
> anything about whether there exist views in the database that were
> created under a different setting.

I realize that; but is it also not the case that someone who creates a
view that requires add_missing_from, and then turns it off, has _already_
broken dump+restore on his own database?

i.e. people who turn off add_missing_from intentionally are not likely to
be using it.

--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services