Re: Dropping a temporary view?

Поиск
Список
Период
Сортировка
От Celia McInnis
Тема Re: Dropping a temporary view?
Дата
Msg-id CAGD6t7JkGN_=rMt+hBv1iyiCttvDTvGFULbYfWhaLgtUi=jYuw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Dropping a temporary view?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
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@gmail.com> wrote:
On Wednesday, March 20, 2024, Celia McInnis <celia.mcinnis@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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Dropping a temporary view?
Следующее
От: Bartosz Chroł
Дата:
Сообщение: pg_dumpall with flag --no-role-passwords omits roles comments as well