Re: Improved \df(+) in psql + backward-compatibility

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: David Fetter <david(at)fetter(dot)org>, PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>, PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Improved \df(+) in psql + backward-compatibility
Date: 2005-09-23 20:32:05
Message-ID: 200509232032.j8NKW5U11857@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches


Seems this item will have to remain for 8.2. I have added this to TODO:

o Display IN, INOUT, and OUT parameters in \df+

It probably requires psql to output newlines in the proper
column, which is already on the TODO list.

---------------------------------------------------------------------------

Tom Lane wrote:
> David Fetter <david(at)fetter(dot)org> writes:
> > I've noticed that \df doesn't do quite what it might when a function
> > is created with named input parameters. Please find enclosed a patch
> > against CVS TIP that does this better.
>
> Meanwhile, getting back to the actual merits of the patch ... this is
> not right yet, because it will do the wrong thing when there are OUT
> parameters. (The proargnames array includes both IN and OUT params,
> and you can't assume that proargnames and proargtypes have corresponding
> subscripts.) It would probably be a good idea to discuss what display
> we want for a function with OUT parameters, anyway. The strict columnar
> representation that \df currently uses doesn't scale very well :-(
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2005-09-23 20:45:02 Re: pg_dump fails to set index ownership
Previous Message Jonathan Beit-Aharon 2005-09-23 20:26:56 Patching dblink.c to avoid warning about open transaction

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2005-09-23 20:36:59 Re: Improve psql's handling of multi-line queries
Previous Message Jonathan Beit-Aharon 2005-09-23 20:26:56 Patching dblink.c to avoid warning about open transaction