| From: | Sean Chittenden <sean(at)chittenden(dot)org> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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-22 03:35:45 |
| Message-ID: | 20031222033545.GA33747@perrin.nxad.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
> > I think the original complaint was misguided and we should not do
> > anything about it. IIRC the complaint amounted to "I have
> > hundreds of schemas and it annoys me that \dn shows them all".
> > How is this different from putting hundreds of tables into one
> > schema and then being annoyed because \dt shows them all? We have
> > other mechanisms available for making \dn selective (ie, you can
> > use a name pattern). If \dn is restricted to showing only schemas
> > in your search path, it will become useless.
>
> I completely agree. It's like saying that \l should only show
> databases you are currently connected to...
For the record and if Tom was referring to me, the example I gave was
to have \dn show all schemas that you have any permissions for, not
that were in the search path. -sc
--
Sean Chittenden
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2003-12-22 04:14:57 | 7.4.1 tag'd and bundled ... |
| Previous Message | Andrew Dunstan | 2003-12-22 01:45:11 | Re: [pgsql-advocacy] PostgreSQL speakers needed for OSCON |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2003-12-22 06:21:59 | cascading column drop to index predicates |
| Previous Message | My Deja | 2003-12-21 22:50:38 | pgAdmin crashes when client_min_messages is set in postgresql.conf |