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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend