Sean Chittenden wrote: > > > 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
Yep, that's what it is. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
