Re: Temporary Views

Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > I can go either way on this.
> 
> AFAICS "create temp view" would have some small advantage of keeping the
> view's name out of possibly-public permanent namespaces, so the step of
> just adding the TEMP option to CREATE VIEW may be worth doing.  The
> advantage isn't very big but neither is the amount of work.

What about indexes?  Do indexes on temp tables exist in the temp
namespace?  I would think they should by default, as well as views based
on temp tables.  Certainly no one else should be able to see the temp
index/views.

> Trying to prohibit non-temp views on temp tables strikes me as more work
> than it's worth; that TODO item was written before we had dependencies,
> and I think it's obsolete.  Basically the point of the TODO was to avoid
> having broken views --- and we have solved that problem.

Yes, if it auto-temps because it is based on a temp object, that is fine
by me.  However, based on your comments above, I think it should
auto-temp fully, rather than just auto-destroy.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073