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