Re: Closing some 8.4 open items

On Sat, Apr 11, 2009 at 5:06 AM, Grzegorz Jaskiewicz
<gj(at)pointblue(dot)com(dot)pl> wrote:
> On 11 Apr 2009, at 08:01, Hitoshi Harada wrote:
>> 2009/4/11 David Fetter <david(at)fetter(dot)org>:
>>> On Sat, Apr 11, 2009 at 03:48:33PM +0900, Hitoshi Harada wrote:
>>>> Yeah, but all the window functions are stored in pg_proc.
>>> So are aggregate functions, and they have their own separate way of
>>> being addressed in psql :)
>> Aggregate functions are stored in pg_aggregate. And they are
>> combinations of plain function which is stored in pg_proc.
> Maybe trigger functions should be displayed separately too than ?

We're up to at least four different categories of functions that
people think might require special treatment: window, trigger, I/O,
everything else. And then there are other categories you might want
to include/exclude: conversion functions, referential integrity
functions, operator functions, ... it quickly gets out of control.

Maybe we should consider some sort of option syntax for blackslash
commands. Like, \df -w to see just window functions, \df -c to see
just conversion functions, \df -wc to see those two types but not
anything else. Actually, I don't really like that syntax either,
because it's just propagating the existing dubious design decision of
identifying the behavior you want with longer and longer strings of
inscrutable single-digit modifiers. But some sort of more powerful
syntax would be good.

This problem is not limited to searching either - for example, I'd
like to be able to do "\d foo, except don't show me the foreign-keys
because there are a zillion of them and they make the output not fit
on the screen".

...Robert