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.