Good, that's what I'd hope. I'm still not sure why it took more than 7 minutes in psql to select the old non-temporary view contents after dropping the newer temporary view of the same name. There were no delays in producing the original non-temporary view. If I can reproduce the problem in psql, I'll re-ask. Meanwhile I'll also change my software to use different view names when using non-temporary iviews for debugging.
Thanks, Celia McInnis On Wed, Mar 20, 2024 at 12:33 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wednesday, March 20, 2024, Celia McInnis <celia.mcin...@gmail.com> > wrote: >> >> >> Is there some reason why it then took 7 minutes to select from the >> non-temporary view tempview after I dropped the temporary view tempview? >> >>> >>> > The fact that you had and then dropped the temporary view has no > relationship to how some other unrelated view performs. That the views > have the same name is just bad naming/design for this very reason; it harms > understanding. > > David J. > >
