Re: Question about TEMP tables

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: Question about TEMP tables
Дата
Msg-id CAMsr+YHZFKuaL0jz-m-mov=4PxsUOVUXArCzK=AmiHAsF-xi+A@mail.gmail.com
обсуждение исходный текст
Ответ на Question about TEMP tables  (Dmitry Voronin <carriingfate92@yandex.ru>)
Ответы Re: Question about TEMP tables  (Воронин Дмитрий <carriingfate92@yandex.ru>)
Список pgsql-hackers
On 16 March 2015 at 16:31, Dmitry Voronin <carriingfate92@yandex.ru> wrote:
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).


This is better suited to the pgsql-general or pgsql-admin mailing lists.

Make sure to show your full command(s) and the full, exact text of any errors.



--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Parallel Seq Scan
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Redesigning checkpoint_segments