Re: Dropping a temporary view?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Celia McInnis <celia(dot)mcinnis(at)gmail(dot)com>
Cc: Erik Wienhold <ewie(at)ewie(dot)name>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Dropping a temporary view?
Date: 2024-03-20 16:33:47
Message-ID: CAKFQuwZ55mpHteRPK7yX=w0iTAdJqo=yUvKPxu_85idxSix_Tg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday, March 20, 2024, Celia McInnis <celia(dot)mcinnis(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Celia McInnis 2024-03-20 16:51:32 Re: Dropping a temporary view?
Previous Message Adrian Klaver 2024-03-20 15:46:54 Re: Dropping a temporary view?