From 9e522d0816a93c6b574109b9b5251371ff6bcd64 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sat, 2 Sep 2006 20:31:50 +0000 Subject: [PATCH] Update: < Last updated: Sat Sep 2 08:31:04 EDT 2006 > Last updated: Sat Sep 2 16:31:46 EDT 2006 < o Allow UPDATE tab SET ROW (col, ...) = (...) for updating multiple < columns > o -Allow UPDATE tab SET ROW (col, ...) = (val, ...) for updating > multiple columns > o Allow UPDATE tab SET ROW (col, ...) = (SELECT...) < A subselect can also be used as the value source. --- doc/TODO | 10 +++---- doc/src/FAQ/TODO.html | 66 +++++++++++++++++++++---------------------- 2 files changed, 37 insertions(+), 39 deletions(-) diff --git a/doc/TODO b/doc/TODO index ab6e4d76ec..4ecae93cb9 100644 --- a/doc/TODO +++ b/doc/TODO @@ -1,8 +1,8 @@ -c + PostgreSQL TODO List ==================== Current maintainer: Bruce Momjian (bruce@momjian.us) -Last updated: Sat Sep 2 08:31:04 EDT 2006 +Last updated: Sat Sep 2 16:31:46 EDT 2006 The most recent version of this document can be viewed at http://www.postgresql.org/docs/faqs.TODO.html. @@ -543,10 +543,10 @@ SQL Commands * UPDATE o -Allow an alias to be provided for the target table in UPDATE/DELETE (Neil) - o Allow UPDATE tab SET ROW (col, ...) = (...) for updating multiple - columns + o -Allow UPDATE tab SET ROW (col, ...) = (val, ...) for updating + multiple columns + o Allow UPDATE tab SET ROW (col, ...) = (SELECT...) - A subselect can also be used as the value source. http://archives.postgresql.org/pgsql-hackers/2006-07/msg01306.php diff --git a/doc/src/FAQ/TODO.html b/doc/src/FAQ/TODO.html index cbe6780e0a..53c70179d4 100644 --- a/doc/src/FAQ/TODO.html +++ b/doc/src/FAQ/TODO.html @@ -2,16 +2,14 @@ "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> -c +PostgreSQL TODO List -

c
-PostgreSQL TODO List -

-Current maintainer: Bruce Momjian (bruce@momjian.us)
-Last updated: Sat Sep 2 08:31:04 EDT 2006 - +

PostgreSQL TODO List

Current maintainer: Bruce Momjian (bruce@momjian.us)
+Last updated: Sat Sep 2 16:31:46 EDT 2006 +

The most recent version of this document can be viewed at
http://www.postgresql.org/docs/faqs.TODO.html.

@@ -24,7 +22,7 @@ Last updated: Sat Sep 2 08:31:04 EDT 2006 you would like to work on an item, please read the Developer's FAQ
first.

Administration

-Make postmater and postgres options distinct so the postmaster -o @@ -152,7 +150,7 @@ first.
Allow the PITR process to be debugged and data examined

Monitoring

Allow server log information to be output as INSERT statements @@ -163,7 +161,7 @@ first.
-Allow server logs to be remotely read and removed using SQL commands
-Allow protocol-level BIND parameter values to be logged, if text mode

Data Types

Improve the MONEY data type @@ -298,7 +296,7 @@ first.

Functions

Allow INET subnet tests using non-constants to be indexed @@ -341,7 +339,7 @@ first.
Add SPI_gettypmod() to return the typemod for a TupleDesc
Allow inlining of set-returning functions

Multi-Language Support

Add NCHAR (as distinguished from ordinary varchar), @@ -372,7 +370,7 @@ first. http://archives.postgresql.org/pgsql-patches/2005-11/msg00173.php

Views / Rules

Automatically create rules on views so they are updateable, per SQL99 @@ -388,7 +386,7 @@ first. are added after the view is created.

SQL Commands

-Change LIMIT/OFFSET and FETCH/MOVE to use int8 @@ -498,10 +496,10 @@ first.
- -Allow an alias to be provided for the target table in UPDATE/DELETE (Neil) -
- Allow UPDATE tab SET ROW (col, ...) = (...) for updating multiple - columns -
  A subselect can also be used as the value source. - http://archives.postgresql.org/pgsql-hackers/2006-07/msg01306.php +
- -Allow UPDATE tab SET ROW (col, ...) = (val, ...) for updating + multiple columns +
- Allow UPDATE tab SET ROW (col, ...) = (SELECT...) +
  http://archives.postgresql.org/pgsql-hackers/2006-07/msg01306.php
ALTER @@ -679,7 +677,7 @@ first.

Clients

-Have initdb set the input DateStyle (MDY or DMY) based on locale @@ -788,7 +786,7 @@ first.

Triggers

Add deferred trigger queue file
Right now all deferred trigger information is stored in backend @@ -816,7 +814,7 @@ first. to fire triggers.

Dependency Checking

Flush cached query plans when the dependent objects change, @@ -833,7 +831,7 @@ first. invalidate its own query plan.

Exotic Features

Add pre-parsing phase that converts non-ISO syntax to supported @@ -860,7 +858,7 @@ first.
http://archives.postgresql.org/pgsql-hackers/2004-04/msg00818.php

Indexes

Allow inherited tables to inherit index, UNIQUE constraint, and primary @@ -927,7 +925,7 @@ first.
Allow multi-column hash indexes

Fsync

Improve commit_delay handling to reduce fsync() @@ -939,7 +937,7 @@ first.
%Add an option to sync() before fsync()'ing checkpoint files
Add program to test if fsync has a delay compared to non-fsync

Cache Usage

Allow free-behind capability for large sequential scans, perhaps using @@ -993,7 +991,7 @@ first.
http://archives.postgresql.org/pgsql-hackers/2005-10/msg01419.php

Vacuum

Improve speed with indexes @@ -1051,12 +1049,12 @@ first.
Turn on by default

Locking

Fix priority ordering of read and write light-weight locks (Neil)

Startup Time Improvements

Experiment with multi-threaded backend for backend creation [thread] @@ -1079,7 +1077,7 @@ first. existing backends is one of the difficulties with a backend approach.

Write-Ahead Log

Eliminate need to write full pages to WAL before page modification [wal] @@ -1143,7 +1141,7 @@ first. of indexes on TOAST tables.

Optimizer / Executor

Improve selectivity functions for geometric operators @@ -1168,7 +1166,7 @@ first.
This might replace GEQO, http://sixdemonbag.org/Djinni.

Miscellaneous Performance

Do async I/O for faster random read-ahead of data @@ -1211,7 +1209,7 @@ first.
Research storing disk pages with no alignment/padding

Source Code

Add use of 'const' for variables in source tree @@ -1293,7 +1291,7 @@ first. of result sets using new statement protocol

Features We Do _Not_ Want

All backends running as threads in a single process (not wanted) @@ -1314,7 +1312,7 @@ first.

Developers who have claimed items are:

Alvaro is Alvaro Herrera <alvherre@dcc.uchile.cl>
Andrew is Andrew Dunstan <andrew@dunslane.net> -- 2.40.0