Question about TEMP tables - Mailing list pgsql-hackers

From Dmitry Voronin
Subject Question about TEMP tables
Date
Msg-id 8797921426512296@web19h.yandex.ru
Whole thread Raw
List pgsql-hackers
Hello, all.

We can create temp namespaces and temp objects that contains it. So, for example, temp table will be create at
pg_temp_N(N - backendID). But afrer cluster init we have pg_temp_1 and pg_toast_temp_1 namespaces with OIDs 11333 and
11334.Those namespaces are visible from any cluster database, but we cannot create any temp objects (please, correct
me).

So, how can we use those namespaces and what are needed for?

Thank you.

-- 
Best regards, Dmitry Voronin



pgsql-hackers by date:

Previous
From: Petr Jelinek
Date:
Subject: Re: Using 128-bit integers for sum, avg and statistics aggregates
Next
From: Kevin Grittner
Date:
Subject: Re: Reduce pinning in btree indexes