Re: Temporary Views

On Tue, 2002-08-13 at 11:11, 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.

I was playing with this a while back (when I had initially added CASCADE
to tables).  I believe that in the event of a crash the temp tables are
not removed until their next use.  This means that stale *real* items
may litter the system but the temp table no longer exists in these rare
occurrences.

However, having all temporary items removed during backend startup would
remove this case.