From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Sean Chittenden <sean(at)chittenden(dot)org>, btober(at)seaworthysys(dot)com, PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | Re: [PATCHES] [GENERAL] Temporary tables and miscellaneous schemas |
Date: | 2003-12-21 05:20:46 |
Message-ID: | 200312210520.hBL5KkL01284@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > Tom Lane wrote:
> >> Oh, okay. I would not object to suppressing pg_temp_NNN schemas from
> >> the \dn display. That isn't what this patch does, however.
>
> > OK. I read the TODO and it says only:
> > * Have psql \dn show only visible schemas using current_schemas()
>
> That TODO was your interpretation of the discussion; I'm not sure anyone
> else bought into it.
>
> > so that's what I did, but I think now I have to add a test so only
> > non-visible temp schemas are suppressed,
>
> You are complicating something that could be simple. Why not just
> suppress schemas named 'pg_temp_XXX', period? I don't see any strong
> reason to display them, whether they are your own backend's temp schema
> or not. Arguably, the fact that temp tables are kept in a special
> schema is an implementation detail that most people won't care about.
> And there is no data that \dn can show that is really important for temp
> schemas. The owner column is at best misleading...
OK, unless someone objects, I will head in that direction.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-12-21 05:21:35 | Re: [GENERAL] Temporary tables and miscellaneous schemas |
Previous Message | Tom Lane | 2003-12-21 05:02:28 | Re: [GENERAL] Temporary tables and miscellaneous schemas |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-12-21 05:21:35 | Re: [GENERAL] Temporary tables and miscellaneous schemas |
Previous Message | Tom Lane | 2003-12-21 05:02:28 | Re: [GENERAL] Temporary tables and miscellaneous schemas |