Re: 7.4 Wishlist

Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> wrote:
> Hi guys,
>
> Just out of interest, if someone was going to pay you to hack on Postgres
> for 6 months, what would you like to code for 7.4?

Well, on top of the oft-requested replication support and savepoint
support, I'd like to see UPDATE, er, updated to be able to make use of
cursors.

I'd also like to see (if this is even possible) a transaction
isolation mode that would make it possible for multiple concurrent
updates to the same row to happen without blocking each other (I
imagine one way to make this possible would be for the last
transaction to commit to be the one that "wins". Each transaction
that commits gets its updates written so that other transactions that
begin after they commit will see them, of course). Neither "read
committed" nor "serialized" modes offer this. Don't know if it's
possible, but it would be nice (such that a transaction sees the
database as if it has it all to itself and doesn't block on
updates)...

- Kevin