Re: what causes new temp schemas to be created

[Ron <ronljohnsonjr@xxxxxxxxx>]

    On 7/10/23 09:20, David G. Johnston wrote:

On Mon, Jul 10, 2023 at 7:18 AM Ted Toth <txtoth@xxxxxxxxx> 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.

    IOW, temporary schemata are how Pg lets different sessions have
    temporary objects use the same name?

--
Born in Arizona, moved to Babylonia.