diff options
| author | Bruce Momjian <bruce@momjian.us> | 2006-08-31 00:34:34 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2006-08-31 00:34:34 +0000 |
| commit | 5bb9c25904bb6fb087fc9bee4b2af3bf86a8d477 (patch) | |
| tree | c7a67fa7b3f47a00223f81d045027dce086d5f18 | |
| parent | 85188ab8838bf19cdf12298e1b6c29e12f9b9a3c (diff) | |
| download | postgresql-5bb9c25904bb6fb087fc9bee4b2af3bf86a8d477.tar.gz postgresql-5bb9c25904bb6fb087fc9bee4b2af3bf86a8d477.zip | |
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'
| -rw-r--r-- | doc/TODO | 10 | ||||
| -rw-r--r-- | doc/src/FAQ/TODO.html | 65 |
2 files changed, 34 insertions, 41 deletions
@@ -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 53adcea4d21..56bfc186800 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"> <html> <head> -<title>PostgreSQL TODO List</title> +<title>c</title> <meta name="generator" content="HTML::TextToHTML v2.25"/> </head> <body bgcolor="#FFFFFF" text="#000000" link="#FF0000" vlink="#A00000" alink="#0000FF"> -<h1><a name="section_1">PostgreSQL TODO List</a></h1> -<p>Current maintainer: Bruce Momjian (<a href="mailto:bruce@momjian.us">bruce@momjian.us</a>)<br/> -Last updated: Tue Aug 29 12:21:52 EDT 2006 -</p> +<p>c<br/> +PostgreSQL TODO List +</p><hr/> +Current maintainer: Bruce Momjian (<a href="mailto:bruce@momjian.us">bruce@momjian.us</a>)<br/> +Last updated: Wed Aug 30 20:34:28 EDT 2006 + <p>The most recent version of this document can be viewed at<br/> <a href="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>. </p> @@ -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<br/> first. </p> -<h1><a name="section_2">Administration</a></h1> +<h1><a name="section_1">Administration</a></h1> <ul> <li>-<em>Make postmater and postgres options distinct so the postmaster -o</em> @@ -150,7 +152,7 @@ first. </li><li>Allow the PITR process to be debugged and data examined </li></ul> </li></ul> -<h1><a name="section_3">Monitoring</a></h1> +<h1><a name="section_2">Monitoring</a></h1> <ul> <li>Allow server log information to be output as INSERT statements @@ -161,7 +163,7 @@ first. </li><li>-<em>Allow server logs to be remotely read and removed using SQL commands</em> </li><li>-<em>Allow protocol-level BIND parameter values to be logged, if text mode</em> </li></ul> -<h1><a name="section_4">Data Types</a></h1> +<h1><a name="section_3">Data Types</a></h1> <ul> <li>Improve the MONEY data type @@ -296,7 +298,7 @@ first. </li></ul> </li></ul> </li></ul> -<h1><a name="section_5">Functions</a></h1> +<h1><a name="section_4">Functions</a></h1> <ul> <li>Allow INET subnet tests using non-constants to be indexed @@ -339,7 +341,7 @@ first. </li><li>Add SPI_gettypmod() to return the typemod for a TupleDesc </li><li>Allow inlining of set-returning functions </li></ul> -<h1><a name="section_6">Multi-Language Support</a></h1> +<h1><a name="section_5">Multi-Language Support</a></h1> <ul> <li>Add NCHAR (as distinguished from ordinary varchar), @@ -370,7 +372,7 @@ first. <a href="http://archives.postgresql.org/pgsql-patches/2005-11/msg00173.php">http://archives.postgresql.org/pgsql-patches/2005-11/msg00173.php</a> </p> </li></ul> -<h1><a name="section_7">Views / Rules</a></h1> +<h1><a name="section_6">Views / Rules</a></h1> <ul> <li>Automatically create rules on views so they are updateable, per SQL99 @@ -386,7 +388,7 @@ first. are added after the view is created. </p> </li></ul> -<h1><a name="section_8">SQL Commands</a></h1> +<h1><a name="section_7">SQL Commands</a></h1> <ul> <li>-<em>Change LIMIT/OFFSET and FETCH/MOVE to use int8</em> @@ -557,12 +559,7 @@ first. the table at the same time, which is something that is currently allowed. </p> - </li><li>Allow COPY (SELECT ...) TO 'filename' -<p> COPY should also be able to output views using COPY (SELECT - </p><ul> - <li>FROM view) TO 'filename' internally. - <a href="http://archives.postgresql.org/pgsql-patches/2005-09/msg00148.php">http://archives.postgresql.org/pgsql-patches/2005-09/msg00148.php</a> - </li></ul> + </li><li>-<em>Allow COPY (SELECT ...) TO 'filename'</em> </li></ul> </li><li>GRANT/REVOKE <ul> @@ -685,7 +682,7 @@ first. </li></ul> </li></ul> </li></ul> -<h1><a name="section_9">Clients</a></h1> +<h1><a name="section_8">Clients</a></h1> <ul> <li>-<em>Have initdb set the input DateStyle (MDY or DMY) based on locale</em> @@ -794,7 +791,7 @@ first. </p> </li></ul> </li></ul> -<h1><a name="section_10">Triggers</a></h1> +<h1><a name="section_9">Triggers</a></h1> <ul> <li>Add deferred trigger queue file <p> Right now all deferred trigger information is stored in backend @@ -822,7 +819,7 @@ first. to fire triggers. </p> </li></ul> -<h1><a name="section_11">Dependency Checking</a></h1> +<h1><a name="section_10">Dependency Checking</a></h1> <ul> <li>Flush cached query plans when the dependent objects change, @@ -839,7 +836,7 @@ first. invalidate its own query plan. </p> </li></ul> -<h1><a name="section_12">Exotic Features</a></h1> +<h1><a name="section_11">Exotic Features</a></h1> <ul> <li>Add pre-parsing phase that converts non-ISO syntax to supported @@ -866,7 +863,7 @@ first. <p> <a href="http://archives.postgresql.org/pgsql-hackers/2004-04/msg00818.php">http://archives.postgresql.org/pgsql-hackers/2004-04/msg00818.php</a> </p> </li></ul> -<h1><a name="section_13">Indexes</a></h1> +<h1><a name="section_12">Indexes</a></h1> <ul> <li>Allow inherited tables to inherit index, UNIQUE constraint, and primary @@ -933,7 +930,7 @@ first. </li><li>Allow multi-column hash indexes </li></ul> </li></ul> -<h1><a name="section_14">Fsync</a></h1> +<h1><a name="section_13">Fsync</a></h1> <ul> <li>Improve commit_delay handling to reduce fsync() @@ -945,7 +942,7 @@ first. </li><li>%Add an option to sync() before fsync()'ing checkpoint files </li><li>Add program to test if fsync has a delay compared to non-fsync </li></ul> -<h1><a name="section_15">Cache Usage</a></h1> +<h1><a name="section_14">Cache Usage</a></h1> <ul> <li>Allow free-behind capability for large sequential scans, perhaps using @@ -999,7 +996,7 @@ first. <p> <a href="http://archives.postgresql.org/pgsql-hackers/2005-10/msg01419.php">http://archives.postgresql.org/pgsql-hackers/2005-10/msg01419.php</a> </p> </li></ul> -<h1><a name="section_16">Vacuum</a></h1> +<h1><a name="section_15">Vacuum</a></h1> <ul> <li>Improve speed with indexes @@ -1057,12 +1054,12 @@ first. </li><li>Turn on by default </li></ul> </li></ul> -<h1><a name="section_17">Locking</a></h1> +<h1><a name="section_16">Locking</a></h1> <ul> <li>Fix priority ordering of read and write light-weight locks (Neil) </li></ul> -<h1><a name="section_18">Startup Time Improvements</a></h1> +<h1><a name="section_17">Startup Time Improvements</a></h1> <ul> <li>Experiment with multi-threaded backend for backend creation [<a href="http://momjian.postgresql.org/cgi-bin/pgtodo?thread">thread</a>] @@ -1085,7 +1082,7 @@ first. existing backends is one of the difficulties with a backend approach. </p> </li></ul> -<h1><a name="section_19">Write-Ahead Log</a></h1> +<h1><a name="section_18">Write-Ahead Log</a></h1> <ul> <li>Eliminate need to write full pages to WAL before page modification [<a href="http://momjian.postgresql.org/cgi-bin/pgtodo?wal">wal</a>] @@ -1149,7 +1146,7 @@ first. of indexes on TOAST tables. </p> </li></ul> -<h1><a name="section_20">Optimizer / Executor</a></h1> +<h1><a name="section_19">Optimizer / Executor</a></h1> <ul> <li>Improve selectivity functions for geometric operators @@ -1174,7 +1171,7 @@ first. <p> This might replace GEQO, <a href="http://sixdemonbag.org/Djinni">http://sixdemonbag.org/Djinni</a>. </p> </li></ul> -<h1><a name="section_21">Miscellaneous Performance</a></h1> +<h1><a name="section_20">Miscellaneous Performance</a></h1> <ul> <li>Do async I/O for faster random read-ahead of data @@ -1217,7 +1214,7 @@ first. </p> </li><li>Research storing disk pages with no alignment/padding </li></ul> -<h1><a name="section_22">Source Code</a></h1> +<h1><a name="section_21">Source Code</a></h1> <ul> <li>Add use of 'const' for variables in source tree @@ -1299,7 +1296,7 @@ first. of result sets using new statement protocol </li></ul> </li></ul> -<h1><a name="section_23">Features We Do _Not_ Want</a></h1> +<h1><a name="section_22">Features We Do _Not_ Want</a></h1> <ul> <li>All backends running as threads in a single process (not wanted) @@ -1320,7 +1317,7 @@ first. </li></ul> <hr/> -<h2><a name="section_23_1">Developers who have claimed items are:</a></h2> +<h2><a name="section_22_1">Developers who have claimed items are:</a></h2> <ul> <li>Alvaro is Alvaro Herrera <<a href="mailto:alvherre@dcc.uchile.cl">alvherre@dcc.uchile.cl</a>> </li><li>Andrew is Andrew Dunstan <<a href="mailto:andrew@dunslane.net">andrew@dunslane.net</a>> |