Re: Closing some 8.4 open items

On Sat, Apr 11, 2009 at 08:52:31AM -0400, Robert Haas wrote:
> 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.

The current psql has \da and \df, the latter of which now includes I/O
functions. I contend that windowing functions are different enough
that they require a separate category.

You do bring up an interesting point for 8.5 or later, which would be
a complete redo of psql from the ground up. Let's hash out a proposal
for that in a separate thread once we get 8.4 out the door :)

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

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