Re: views on temp tables

Tom Lane wrote:
> Neil Conway <nconway@klamath.dyndns.org> writes:
> > Currently, PostgreSQL allows this -- when the session ends and the temp
> > table is dropped, an subsequent queries on the view fail. Is this the
> > optimal behavior?
> 
> Well, I think it's better than refusing views on temp tables, as the
> spec would have us do.
> 
> The "correct" behavior is probably to drop such views on backend exit.
> Possibly we should invent the notion of temp views, and disallow
> references from non-temp views to temp tables.  That seems like it
> might be less likely to cause unpleasant surprises than just silently
> dropping views that reference temp tables.

TODO updated with:* Allow temporary views* Require view using temporary tables to be temporary views

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026