Re: Temporary Views

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> so, added to TODO:
>   * Have views on temporary tables exist in the temporary namespace 
> TODO updated to remove mention of temporary views.

That's *clearly* backwards.  Ignoring our little argument, I think there
is no denying that temp views as such are useful --- for example,
consider a temp view created on permanent tables to define a
session-local shorthand for a complex query.

If you want a restriction, make it* Invent temporary views* Restrict permanent views from referring to temporary
tables
I agree with the first goal and disagree with the second --- but I can
see your point of view on the second.  OTOH I can't see any reason to
hardwire tempness-of-views to tempness-of-referenced-tables, because
that disallows the obviously useful case of temp view on permanent
table.

> I just removed them:
>   * Allow temporary views
>   * Require view using temporary tables to be temporary views

It was right the first time.
        regards, tom lane