| From: | Sean Chittenden <sean(at)chittenden(dot)org> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, btober(at)seaworthysys(dot)com, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Temporary tables and miscellaneous schemas |
| Date: | 2003-10-27 17:24:55 |
| Message-ID: | 20031027172454.GQ86551@perrin.nxad.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> > If you see a pg_temp_* for every connection, that is a little
> > overwhelming. pg_toast and stuff aren't really too bad. Is there
> > any way to access your local temp schema in a way that doesn't
> > show the others? Could we use backend_pid in the query and show
> > them only their own?
>
> I have created the following patch for 7.5. It has \dn show only
> your local pg_temp_* schema, and only if you own it --- there might
> be an old temp schema around from an old backend.
>
> This patch requires a new function pg_stat_backend_id which returns
> your current slot id (not your pid) --- that would be separate
> addition.
If by slot, you mean connection ID, then this sounds like a good
compromise/patch to me. -sc
--
Sean Chittenden
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-10-27 17:25:29 | Re: Temporary tables and miscellaneous schemas |
| Previous Message | Bruce Momjian | 2003-10-27 17:21:48 | Re: Recomended FS |