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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster