Question about TEMP tables

From: Dmitry Voronin <carriingfate92(at)yandex(dot)ru>
To: PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Question about TEMP tables
Date: 2015-03-16 13:24:56
Message-ID: 8797921426512296@web19h.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2015-03-16 13:32:58 Re: Reduce pinning in btree indexes
Previous Message Kevin Grittner 2015-03-16 13:23:58 Re: Reduce pinning in btree indexes