On Tue, 2002-08-13 at 11:11, Tom Lane wrote: > Gavin Sherry <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
