Re: Temporary Views - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Temporary Views
Date
Msg-id 26824.1029255758@sss.pgh.pa.us
Whole thread Raw
In response to Re: Temporary Views  (Rod Taylor <rbt@zort.ca>)
Responses Re: Temporary Views  (Rod Taylor <rbt@zort.ca>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Please, apply patch for contrib/tsearch
Next
From: Oleg Bartunov
Date:
Subject: Re: db partial dumping with pg_dump