| From: | Sean Chittenden <sean(at)chittenden(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>, btober(at)seaworthysys(dot)com |
| Subject: | Re: [GENERAL] Temporary tables and miscellaneous schemas |
| Date: | 2003-12-21 06:00:11 |
| Message-ID: | 20031221060011.GA93411@perrin.nxad.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
> > 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?
Because that's what I originally did and you shot it down as a bad
patch because you thought it wasn't in PostgreSQL's interest to filter
what we showed the user.
"What have you got against pg_temp? If we think \dn shouldn't show those
schemas, shouldn't it suppress *all* system schemas, including
pg_catalog and pg_toast? Maybe information_schema as well?"
I'm glad to see you've come around on this given temp structures show
up regardless of the temp schema (which is, as you point out, an
implementation detail that users need not concern themselves with).
Patch/thread:
http://archives.postgresql.org/pgsql-general/2003-10/msg00613.php
-sc
--
Sean Chittenden
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-12-21 06:03:00 | Re: [GENERAL] Temporary tables and miscellaneous schemas |
| Previous Message | Bruce Momjian | 2003-12-21 05:26:47 | Re: [GENERAL] Temporary tables and miscellaneous schemas |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-12-21 06:03:00 | Re: [GENERAL] Temporary tables and miscellaneous schemas |
| Previous Message | Bruce Momjian | 2003-12-21 05:26:47 | Re: [GENERAL] Temporary tables and miscellaneous schemas |