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. I can go either way, but I want to make sure we agree so I can modify the TODO accordingly. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
