On 7/10/23 09:20, David G. Johnston wrote:
On Mon, Jul 10, 2023 at 7:18 AM Ted Toth <txt...@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.
IOW, temporary schemata are how Pg lets different sessions have temporary objects use the same name?
-- Born in Arizona, moved to Babylonia.
