Re: what causes new temp schemas to be created

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Ted Toth <txtoth(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: what causes new temp schemas to be created
Date: 2023-07-10 14:20:43
Message-ID: CAKFQuwbd8FzBYBKSvjZ8fGq+AU=r+OCXTKoyyO-qandwtA8huQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jul 10, 2023 at 7:18 AM Ted Toth <txtoth(at)gmail(dot)com> wrote:

> When a temp table is created I see a pg_temp_NNN (for example
> pg_temp_3, pg_toast_temp_3) schemas created when/why are additional
> temp schemas created( pg_temp_4/pg_toast_temp_4)?
>
>
Temporary schemas are isolated to the session they are created in. Hence,
you get multiple temporary schemas if you have concurrent sessions using
temporary objects.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2023-07-10 14:28:10 Re: what causes new temp schemas to be created
Previous Message Ted Toth 2023-07-10 14:18:32 what causes new temp schemas to be created