Tom,
> > 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?
>
> Yes, you only need to get it past the parser during CREATE VIEW.
Then the proposal sounds like a good solution to me. It would still be nice
to emit a warning, as well, if that's reasonably easy to do.
--
Josh Berkus
Aglio Database Solutions
San Francisco