On Tue, 2002-08-13 at 11:18, Bruce Momjian wrote: > 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. > > 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
