Gregory Stark <[EMAIL PROTECTED]> writes:
> It might be cute to see if the pattern matches any user functions and if not
> try again with system functions. So you would still get results if you did 
> "\df rtrim" for example.

Interesting idea.  IIUC, \df would give you either all user functions
*or* all system functions depending on the actual catalog contents,
while \dfS would always give you just system functions.  That means
there'd be no way to replicate the all-functions-of-both-types behavior
that has been the default in every prior release.  That sounds like
a recipe for getting complaints --- changing the default behavior is
one thing, but making it so that that behavior isn't available at
all is surely going to break somebody's code or habitual usage.

How about

        \dfS    -> sys functions only
        \dfU    -> user functions only
        \dfSU   -> all functions (should allow \dfUS spelling too)
        \df     -> behavior proposed by Greg

(and similarly for all other \d commands of course).  Then anyone
who's depending on the old behavior can still get it with a couple
more keystrokes.

BTW, should we remove the special hack that discriminates against
showing I/O functions (or really anything that touches cstring) in \df?
ISTM that was mostly there to reduce clutter, and this proposal solves
that problem more neatly.  I know I've cursed that behavior under my
breath more than once, but again maybe my usage isn't typical.

                        regards, tom lane

Sent via pgsql-patches mailing list (
To make changes to your subscription:

Reply via email to