Re: 7.4 Wishlist - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: 7.4 Wishlist
Date
Msg-id 09cf01c2980b$4fcd1de0$6500a8c0@internal
Whole thread Raw
In response to Re: 7.4 Wishlist  (Philip Warner <pjw@rhyme.com.au>)
Responses Re: 7.4 Wishlist
List pgsql-hackers
> I've actually started working on pg_dump in the background, but if you
want
> to do it let me know.

Nah - you can do it!  I don't have much time to code Postgres as it is.
I'll stick to working on making ADD COLUMN compliant.

> In terms of things I would like to see:
>
> - background/integrated vacuum (not just an overwriting storage manager)

Work has started on this already, which is neat.

> - insert/update...returning

That would be so useful for our web app where we're always needing to get
the primary key as opposed to oid.  We keep needing to requery.

> - function result caches -- assuming I can demonstrate that they are a
Good
> Thing.
>
> - COPY TO/FROM with a list of columns (maybe we have it?) - it's useful
for
> making metadata changes then reloading data (Inserts are much slower).

We do already have it in 7.3:

http://developer.postgresql.org/docs/postgres/sql-copy.html

Chris



pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Postgres 7.3 announcement on postgresql.org
Next
From: Philip Warner
Date:
Subject: Re: 7.4 Wishlist