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