Re: Temporary Views

On Tue, 2002-08-13 at 11:18, Bruce Momjian wrote:
> Tom Lane wrote:
> > Gavin Sherry <swm@linuxworld.com.au> writes:
> > > I'm thinking that temporary views should be pretty trivial to
> > > implement.
> > 
> > ... except not so trivial, per the rest of your note.
> > 
> > Do we actually need any such feature?  Views on temp tables already work
> > correctly in CVS tip: the implicit DROP CASCADE on temp tables at
> > backend exit makes such views go 'way too.
> 
> Oh.  but RESTRICT is the default.  Seems like the view should go away no
> matter what, and if they mix temp and non-temp tables, is it obvious
> that the view will disappear if they didn't specify TEMP on view
> creation.

When the backend exits the code that removes temp tables is CASCADE by
default and anything depending on it will disappear.