Re: Which backend using which pg_temp_N schema?

2018-06-06 Thread Adrian Klaver
On 06/06/2018 02:00 PM, Jerry Sievers wrote: Adrian Klaver writes: On 06/06/2018 08:54 AM, Jerry Sievers wrote: Adrian Klaver writes: Yep thanks... but IMO something that simply exposes whatever internal registry of temp schemas/PIDs (which I presume must exist) to DBA SQL avoids any perh

Re: Which backend using which pg_temp_N schema?

2018-06-06 Thread Jerry Sievers
Adrian Klaver writes: > On 06/06/2018 08:54 AM, Jerry Sievers wrote: > >> Adrian Klaver writes: >> >> >> Yep thanks... but IMO something that simply exposes whatever internal >> registry of temp schemas/PIDs (which I presume must exist) to DBA SQL >> avoids any perhaps unreliable hackery such as

Re: Which backend using which pg_temp_N schema?

2018-06-06 Thread Adrian Klaver
On 06/06/2018 08:54 AM, Jerry Sievers wrote: Adrian Klaver writes: On 06/05/2018 04:49 PM, Jerry Sievers wrote: Adrian Klaver writes: On 06/05/2018 02:53 PM, Jerry Sievers wrote: Was just studying a legacy DB to learn about temp table activity. Felt like being able to tie temp schemas

Re: Which backend using which pg_temp_N schema?

2018-06-06 Thread Jerry Sievers
Tom Lane writes: > Jerry Sievers writes: > >> Yep thanks... but IMO something that simply exposes whatever internal >> registry of temp schemas/PIDs (which I presume must exist) > > Not really. There are a couple of ways that one could identify a > session's "BackendId", which is the "N" in the

Re: Which backend using which pg_temp_N schema?

2018-06-06 Thread Tom Lane
Jerry Sievers writes: > Yep thanks... but IMO something that simply exposes whatever internal > registry of temp schemas/PIDs (which I presume must exist) Not really. There are a couple of ways that one could identify a session's "BackendId", which is the "N" in the "pg_temp_N" name of the temp

Re: Which backend using which pg_temp_N schema?

2018-06-06 Thread Jerry Sievers
Adrian Klaver writes: > On 06/05/2018 04:49 PM, Jerry Sievers wrote: > >> Adrian Klaver writes: >> >>> On 06/05/2018 02:53 PM, Jerry Sievers wrote: >>> Was just studying a legacy DB to learn about temp table activity. Felt like being able to tie temp schemas to live backends s/b u

Re: Which backend using which pg_temp_N schema?

2018-06-06 Thread Adrian Klaver
On 06/05/2018 04:49 PM, Jerry Sievers wrote: Adrian Klaver writes: On 06/05/2018 02:53 PM, Jerry Sievers wrote: Was just studying a legacy DB to learn about temp table activity. Felt like being able to tie temp schemas to live backends s/b useful but then didn't find a function/view for doi

Re: Which backend using which pg_temp_N schema?

2018-06-05 Thread Jerry Sievers
Adrian Klaver writes: > On 06/05/2018 02:53 PM, Jerry Sievers wrote: > >> Was just studying a legacy DB to learn about temp table activity. >> >> Felt like being able to tie temp schemas to live backends s/b useful but >> then didn't find a function/view for doing this. > > I don't understand wha

Re: Which backend using which pg_temp_N schema?

2018-06-05 Thread Adrian Klaver
On 06/05/2018 02:53 PM, Jerry Sievers wrote: Was just studying a legacy DB to learn about temp table activity. Felt like being able to tie temp schemas to live backends s/b useful but then didn't find a function/view for doing this. I don't understand what the above is getting at. Can you expl

Which backend using which pg_temp_N schema?

2018-06-05 Thread Jerry Sievers
Was just studying a legacy DB to learn about temp table activity. Felt like being able to tie temp schemas to live backends s/b useful but then didn't find a function/view for doing this. A quic \df for functions with names likely to be fruitful revealed nothing. Did likewise for sysinfo views.