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.johnston@xxxxxxxxx> wrote:
On Wednesday, March 20, 2024, Celia McInnis <celia.mcinnis@xxxxxxxxx> 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.
