Re: Temporary Views

Rod Taylor <rbt@zort.ca> writes:
> 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.

Huh?  The view goes away at exactly the same time the temp table does.
If you suffer a backend crash then that may be postponed ... but the
view continues to work up till the instant that it's removed.
        regards, tom lane