From 5bb9c25904bb6fb087fc9bee4b2af3bf86a8d477 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 31 Aug 2006 00:34:34 +0000 Subject: [PATCH] Done: < Last updated: Tue Aug 29 12:21:52 EDT 2006 > Last updated: Wed Aug 30 20:34:28 EDT 2006 < o Allow COPY (SELECT ...) TO 'filename' < < COPY should also be able to output views using COPY (SELECT < * FROM view) TO 'filename' internally. < http://archives.postgresql.org/pgsql-patches/2005-09/msg00148.php > o -Allow COPY (SELECT ...) TO 'filename' --- doc/TODO | 10 ++----- doc/src/FAQ/TODO.html | 65 +++++++++++++++++++++---------------------- 2 files changed, 34 insertions(+), 41 deletions(-) diff --git a/doc/TODO b/doc/TODO index 954792e405..7c51836407 100644 --- a/doc/TODO +++ b/doc/TODO @@ -1,8 +1,8 @@ - +c PostgreSQL TODO List ==================== Current maintainer: Bruce Momjian (bruce@momjian.us) -Last updated: Tue Aug 29 12:21:52 EDT 2006 +Last updated: Wed Aug 30 20:34:28 EDT 2006 The most recent version of this document can be viewed at http://www.postgresql.org/docs/faqs.TODO.html. @@ -612,11 +612,7 @@ SQL Commands the table at the same time, which is something that is currently allowed. - o Allow COPY (SELECT ...) TO 'filename' - - COPY should also be able to output views using COPY (SELECT - * FROM view) TO 'filename' internally. - http://archives.postgresql.org/pgsql-patches/2005-09/msg00148.php + o -Allow COPY (SELECT ...) TO 'filename' * GRANT/REVOKE diff --git a/doc/src/FAQ/TODO.html b/doc/src/FAQ/TODO.html index 53adcea4d2..56bfc18680 100644 --- a/doc/src/FAQ/TODO.html +++ b/doc/src/FAQ/TODO.html @@ -2,14 +2,16 @@ "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> -PostgreSQL TODO List +c -

PostgreSQL TODO List

Current maintainer: Bruce Momjian (bruce@momjian.us)
-Last updated: Tue Aug 29 12:21:52 EDT 2006 -

c
+PostgreSQL TODO List +

+Current maintainer: Bruce Momjian (bruce@momjian.us)
+Last updated: Wed Aug 30 20:34:28 EDT 2006 +

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

@@ -22,7 +24,7 @@ Last updated: Tue Aug 29 12:21:52 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 @@ -150,7 +152,7 @@ first.
Allow the PITR process to be debugged and data examined

Monitoring

Allow server log information to be output as INSERT statements @@ -161,7 +163,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 @@ -296,7 +298,7 @@ first.

Functions

Allow INET subnet tests using non-constants to be indexed @@ -339,7 +341,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), @@ -370,7 +372,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 @@ -386,7 +388,7 @@ first. are added after the view is created.

SQL Commands

-Change LIMIT/OFFSET and FETCH/MOVE to use int8 @@ -557,12 +559,7 @@ first. the table at the same time, which is something that is currently allowed.
-
Allow COPY (SELECT ...) TO 'filename' -
COPY should also be able to output views using COPY (SELECT -
- FROM view) TO 'filename' internally. - http://archives.postgresql.org/pgsql-patches/2005-09/msg00148.php -
+
-Allow COPY (SELECT ...) TO 'filename'

GRANT/REVOKE

@@ -685,7 +682,7 @@ first.

Clients

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

Triggers

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

Dependency Checking

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

Exotic Features

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

Indexes

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

Fsync

Improve commit_delay handling to reduce fsync() @@ -945,7 +942,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 @@ -999,7 +996,7 @@ first.
http://archives.postgresql.org/pgsql-hackers/2005-10/msg01419.php

Vacuum

Improve speed with indexes @@ -1057,12 +1054,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] @@ -1085,7 +1082,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] @@ -1149,7 +1146,7 @@ first. of indexes on TOAST tables.

Optimizer / Executor

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

Miscellaneous Performance

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

Source Code

Add use of 'const' for variables in source tree @@ -1299,7 +1296,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) @@ -1320,7 +1317,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