Postgres Pro
Downloads
Home   >   mailing lists

Re: what causes new temp schemas to be created - Mailing list pgsql-general

From David G. Johnston
Subject Re: what causes new temp schemas to be created
Date
Msg-id CAKFQuwbd8FzBYBKSvjZ8fGq+AU=r+OCXTKoyyO-qandwtA8huQ@mail.gmail.com
Whole thread Raw
In response to what causes new temp schemas to be created  (Ted Toth <txtoth@gmail.com>)
Responses Re: what causes new temp schemas to be created  (Ron <ronljohnsonjr@gmail.com>)
Re: what causes new temp schemas to be created  (Ted Toth <txtoth@gmail.com>)
List pgsql-general
Tree view
On Mon, Jul 10, 2023 at 7:18 AM Ted Toth <txtoth@gmail.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.

pgsql-general by date:

Previous
From: Ted Toth
Date:
Subject: what causes new temp schemas to be created
Next
From: Ron
Date:
Subject: Re: what causes new temp schemas to be created