Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Temporary tables and miscellaneous schemas

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,Sean Chittenden <sean(at)chittenden(dot)org>, btober(at)seaworthysys(dot)com
Subject: Re: [GENERAL] Temporary tables and miscellaneous schemas
Date: 2003-12-21 04:26:04
Message-ID: 200312210426.hBL4Q4V15913@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
pgman wrote:
> Tom Lane wrote:
> > Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > > How about if we add a UNION that does:
> > > 	UNION
> > > 	SELECT 'non-local temp schemas skipped', NULL
> > 
> > I think showing that would only be appropriate if we actually *did* skip
> > some.  Finding that out would complicate the query unduly IMHO.
> > 
> > > I see a few goals here:
> > > 	Prevent \dn from showing lots of lines for large installs
> > > 	Show the local temp schema so people can query it
> > 
> > If those are agreed to be the goals then we end up with your original
> > solution (or a working implementation of same anyway).
> > 
> > I'd like to see some input from other people about what they want...
> 
> I have added this to the TODO list:
> 
> 	* Have psql \dn show only visible schemas using current_schemas()
> 
> I know there was talk of showing all schemas only in admin mode, but I
> don't think we want to implement different behavior until we have a more
> practical reason to have such a mode distiction.  Of course, \dn will
> have to be documented that is supresses non-visible schemas, and admins
> can always do a select from pg_namespace.

This patch uses current_schemas('true') to display only the schemas in
the current search path and implicit schemas.

It uses an array with =ANY(), which we already do in psql's describe.c
for groups.  I also had to use :: for casting because that's the only
way to cast function parameters, I think.

-- 
  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

Responses

pgsql-hackers by date

Next:From: Christopher BrowneDate: 2003-12-21 04:30:57
Subject: Re: [pgsql-advocacy] PostgreSQL speakers needed for OSCON 2004
Previous:From: Tom LaneDate: 2003-12-21 03:54:13
Subject: Re: [HACKERS] PostgreSQL speakers needed for OSCON 2004

pgsql-patches by date

Next:From: Zach IrmenDate: 2003-12-21 04:33:02
Subject: psql \i handling ~ in specified file name
Previous:From: Tom LaneDate: 2003-12-20 19:11:29
Subject: Re: pgsql-server/ oc/src/sgml/datatype.sgml rc/bac ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group