Re: FWD: Re: Updated backslash consistency patch

Bruce Momjian wrote:
> Peter Eisentraut wrote:
>> Bruce Momjian wrote:
>>>> Here's an updated version of the psql backslash patch that should
>>>> apply cleanly to the current HEAD. To recap, this makes all the \dX
>>>> commands (most importantly to most: \df) work like \dt does, in that it
>>>> requires a \dXS to see system items. See the archives for much more
>>>> discussion on the issue.
>>> Patch applied, thanks.
>> This patch has annoyed me twice in two days now, and similarly with 
>> other people I know.  Having to type \dfS now is about the worst loss of 
>> usability in psql that I can recall.  Can we reconsider or revert this?
> 
> Well, \dT is even worse.  ;-)  (How many users have user-defined types?)
> 
> The basic goal of the patch was to make 'S' consistent for all \d
> backslash commands, and we had a lot of discussion about it, and many
> people asked for it (I can't find my user functions).  It is hard to
> argue that our previous behavior was logical (though perhaps useful).

Consistency is nice, but I'm used to typing \df pg_foobar() as well. 
Could we make plain "\df" list only user functions, but "\df XXX" search 
for system functions as well? And the same for all \d* commands, for the 
consistency.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com