On 7/10/23 09:20, David G. Johnston 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.