Re: Consistent \d commands in psql - Mailing list pgsql-patches

From David Fetter
Subject Re: Consistent \d commands in psql
Date
Msg-id 20080401200613.GG25159@fetter.org
Whole thread Raw
In response to Re: Consistent \d commands in psql  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Consistent \d commands in psql  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
On Tue, Apr 01, 2008 at 12:58:44AM -0400, Tom Lane wrote:
> Gregory Stark <stark@enterprisedb.com> writes:
> >>> One --perhaps nice, perhaps not-- property of this is that if
> >>> you defined a function named "rtrim" and then did "\df rtrim" it
> >>> would show you _both_ the system and user function and make it
> >>> easier to see the conflict. Whereas the other behaviour I
> >>> proposed would hide the system function which might exacerbate
> >>> the user's confusion.
>
> >> Another way we could approach this is ...
>
> > That doesn't satisfy the original source of the annoyance which is
> > that \df spams your terminal with ten screens of system functions
> > with your user functions hidden amongst them.
>
> Sure, but I think the core objection there is that there is no easy
> way to see only the user-defined functions.  Given your point quoted
> first above, I'm unconvinced that should be the default behavior.

When we have a bad default--and I'd argue that for anyone not
developing PostgreSQL itself, showing system functions is a bad
default--we should change it to something sane.

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

pgsql-patches by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Improve shutdown during online backup
Next
From: Tom Lane
Date:
Subject: Re: Consistent \d commands in psql