Re: 7.4 Wishlist - Mailing list pgsql-hackers

From Kevin Brown
Subject Re: 7.4 Wishlist
Date
Msg-id 20021204215730.GB31342@filer
Whole thread Raw
In response to 7.4 Wishlist  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Responses Re: 7.4 Wishlist
List pgsql-hackers
Christopher Kings-Lynne <chriskl@familyhealth.com.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


pgsql-hackers by date:

Previous
From: Patrick Welche
Date:
Subject: 24:00:00 ?
Next
From: Tomas Berndtsson
Date:
Subject: Re: big text field -> message type 0x44