Scott Bailey <artacus(at)comcast(dot)net> writes:
> Proposal: Add an invalid flag to pg_class. Invalid objects would be
> ignored when doing dependency checks for DDL statements. And an
> exception would be thrown when an invalid object is called.
IMO, the way Oracle does this pretty much sucks, and shouldn't be
emulated. If they know how to recompile the view, why don't they
just do it? What you describe is about as user-unfriendly as it
gets.
regards, tom lane