Re: add_missing_from breaks existing views

[Josh Berkus <josh(at)agliodbs(dot)com>]

Andrew,

> My suggestion was to set add_missing_from _in the output of pg_dump_ (or
> pg_restore) so that affected views would restore correctly. This would
> affect only the session in which the dump was restored. The changes that
> were already suggested (and since implemented, iiuc) would then make this
> unnecessary for future dumps/restores, and there would be no question of
> setting
> add_missing_from globally in the 8.1 database (unless the admin did that
> explicitly, themselves).

That sounds good if it works.  However ... will an add_missing_from view work 
if add_missing_from is off in the session where the query is executed?   If 
not, then I don't really find this  a solution.  In that case, it would be 
better to supply a script that allows users to find add_missing_from 
dependant views so they can fix them.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco