From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Joe Conway <mail(at)joeconway(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-patches(at)postgresql(dot)org |
Subject: | Re: small psql patch - show Schema name for \dt \dv \dS |
Date: | 2002-08-01 23:16:37 |
Message-ID: | 200208012316.g71NGbM17296@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
Joe Conway wrote:
> Bruce Momjian wrote:
> > I just added pg_stat_get_backend_mypid() that returns the pid. Does
> > that help you?
>
> Sorry for the slow response.
>
> Backend pid doesn't solve this issue, because the temp schema name for a
> logged-in user is based on MyBackendId, not pid, i.e. your temp schema
> name is something like pg_temp_1 when MyBackendId = 1, etc. It would be
> easy enough to write a function exposing this, the question is whether
> it is desirable to expose it?
I see pg_stat_get_backend_idset() and pg_stat_get_backend_pid(), seems we
should report the slot of the current backend.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-08-01 23:30:36 | Re: anonymous composite types for Table Functions (aka SRFs) |
Previous Message | Joe Conway | 2002-08-01 23:12:39 | Re: small psql patch - show Schema name for \dt \dv \dS |