Re: [HACKERS] Raising funds for PostgreSQL

The Hermit Hacker wrote:

> Hi Kyle...
>
>         Jeff is currently in the process of redoing the web site, and
> we're going to be working this 'bidding' system into the new site, but its
> going to take a litlte bit of time, since he would like to get it right
> and not have to do it again :)
>
>         Keep an eye on the sight and expect *a variant* on what you
> proposed to be in place around the first of the new year...but it will be
> implemented...
>

Sounds good.  I hope my input will prove helpful.

BTW, you don't have to wait for the web site to be working right to get me involved
(although I think that might help others to get more involved).

If you're interested in getting some money to help out with development now, this is
the list of things I have been hoping for.  I'm sure my modest contribution alone is
not enough to justify the work they will take, but its probably better than a kick in
the butt.

  - Allow a view of a union
  - Get rid of size restrictions on tuples (8K?)
  - Get rid of size restrictions on queries (16K)
  - Make sequences roll back on abort (at least optionally)
  - Resident functions that can execute with super-privileges
    This would mean that a PL function could execute as the user who created
    it (or perhaps some other user the database creater might specify).  This
    would allow certain information to come from a table that the calling user
    might not normally have access to (without having access to the whole table).
  - Support for outer (and other kinds of) joins
  - Column based permissions (I don't know if there are SQL standards for this)
  - Support for passwords in the TCL interface (is it there now?)
  - Could a subquery be included in the target list of a query
    select a,(select b from c) from d where e = f;
    (Not sure if this one is even standard SQL.)
  - Support for "alter table drop column"

Maybe some of the things have been done already.  Some have not.  The items are
roughly prioritized for our needs here at ATI.

If I knew that certain of these could be accomplished and for how much, that would
really help me move forward.