Re: [HACKERS] Question about TEMP tables

2015-03-17 Thread David G. Johnston
On Tuesday, March 17, 2015, Воронин Дмитрий wrote: > > Make sure to show your full command(s) and the full, exact text of any > errors. > > OK, I use PostgreSQL version 9.4.1. > > I create cluster 'main' and connect to it. After cluster init we have > those shemas: > > postgres=# SELECT nspname

Re: [HACKERS] Question about TEMP tables

2015-03-17 Thread Воронин Дмитрий
> Make sure to show your full command(s) and the full, exact text of any > errors. OK, I use PostgreSQL version 9.4.1. I create cluster 'main' and connect to it. After cluster init we have those shemas: postgres=# SELECT nspname FROM pg_namespace ; nspname p

[HACKERS] Question about TEMP tables

2015-03-17 Thread Воронин Дмитрий
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

Re: [HACKERS] Question about TEMP tables

2015-03-16 Thread Craig Ringer
On 16 March 2015 at 16:31, Dmitry Voronin 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 > 1133

[HACKERS] Question about TEMP tables

2015-03-16 Thread Dmitry Voronin
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

[HACKERS] Question about TEMP tables

2015-03-16 Thread Dmitry Voronin
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 datab