From aa3f396aca648134a90a5f899d960fafa3c433a8 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Tue, 19 Sep 2006 19:20:00 +0000 Subject: Remove completed TODO items: < * -Make postmater and postgres options distinct so the postmaster -o < option is no longer needed < * -Allow pooled connections to list all prepared statements < < This would allow an application inheriting a pooled connection to know < the statements prepared in the current session. < < * -Re-enable the GUC full_page_writes in 8.2 when reliability issues have < been addressed < o -Add "include file" functionality in postgresql.conf < o -Allow per-database permissions to be set via GRANT < < Allow database connection checks based on GRANT rules in < addition to the existing access checks in pg_hba.conf. < < o -Issue a warning if a change-on-restart-only postgresql.conf value > o Issue a warning if a change-on-restart-only postgresql.conf value < o -Automatically force archiving of partially-filled WAL files when < pg_stop_backup() is called or the server is stopped < o -Add reporting of the current WAL file and offset, perhaps as < part of partial log file archiving < * -Allow server logs to be remotely read and removed using SQL commands < * -Allow protocol-level BIND parameter values to be logged < * -Zero umasked bits in conversion from INET cast to CIDR < * -Prevent INET cast to CIDR from dropping netmask, SELECT '1.1.1.1'::inet::cidr < * -Allow INET + INT8 to increment the host part of the address or < throw an error on overflow < * -Add 'tid != tid ' operator for use in corruption recovery < o -Allow customization of the known set of TZ names (generalize the < present australian_timezones hack) < o -Allow timezone names in SQL strings, '2006-05-24 21:11 < Americas/New_York'::timestamptz < o -Add support for day-time syntax, INTERVAL '1 2:03:04' DAY TO < SECOND < o -Allow NULLs in arrays < * -Add transaction_timestamp(), statement_timestamp(), clock_timestamp() < functionality < < Current CURRENT_TIMESTAMP returns the start time of the current < transaction, and gettimeofday() returns the wallclock time. This will < make time reporting more consistent and will allow reporting of < the statement start time. < < * -Allow to_char() to print localized month names < * -Add sleep() function, remove from regress.c < * -Allow user-defined functions retuning a domain value to enforce domain < constraints < * -Allow TRUNCATE ... CASCADE/RESTRICT < < This is like DELETE CASCADE, but truncates. < < * -Add COMMENT ON for all cluster global objects (roles, databases < and tablespaces) < * -Make row-wise comparisons work per SQL spec < < Right now, '(a, b) < (1, 2)' is processed as 'a < 1 and b < 2', but < the SQL standard requires it to be processed as a column-by-column < comparison, so the proper comparison is '(a < 1) OR (a = 1 AND b < 2)'. < < * -Enable escape_string_warning and standard_conforming_strings > * Enable standard_conforming_strings < o -Add ON COMMIT capability to CREATE TABLE AS ... SELECT < o -Allow an alias to be provided for the target table in < UPDATE/DELETE (Neil) < o -Allow UPDATE tab SET ROW (col, ...) = (val, ...) for updating < multiple columns < o -Add ALTER TABLE tab INHERIT / NO INHERIT parent < o -Have COPY return the number of rows loaded/unloaded? < o -Allow COPY (SELECT ...) TO 'filename' < < o -Allow pooled connections to list all open WITH HOLD cursors < < Because WITH HOLD cursors exist outside transactions, this allows < them to be listed so they can be closed. < < o -Allow INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..) < o -Allow INSERT/UPDATE ... RETURNING new.col or old.col < o -Allow PL/python to return composite types and result sets < < * -Have initdb set the input DateStyle (MDY or DMY) based on locale < o -Improve psql's handling of multi-line statements < < Currently, while \e saves a single statement as one entry, interactive < statements are saved one line at a time. Ideally all statements < would be saved like \e does. < < o -Allow multi-line column values to align in the proper columns < < If the second output column value is 'a\nb', the 'b' should appear < in the second display column, rather than the first column as it < does now. < < o -Display IN, INOUT, and OUT parameters in \df < o -Allow pg_dump to use multiple -t and -n switches, exclusion < ability, and regular expression object matching < o -Update pg_dump and psql to use the new COPY libpq API (Christopher) < o -Add a function to support Parse/DescribeStatement capability < * -Add fillfactor to control reserved free space during index creation < * -Add system view to show free space map contents < * -Allow installing to directories containing spaces < < This is possible if proper quoting is added to the makefiles for the < install targets. Because PostgreSQL supports relocatable installs, it < is already possible to install into a directory that doesn't contain < spaces and then copy the install to a directory with spaces. < < * -%Clean up compiler warnings (especially with gcc version 4) < * -Remove BeOS and QNX-specific code < o -Port contrib/xml2 --- doc/src/FAQ/TODO.html | 116 +++++--------------------------------------------- 1 file changed, 11 insertions(+), 105 deletions(-) (limited to 'doc/src') diff --git a/doc/src/FAQ/TODO.html b/doc/src/FAQ/TODO.html index a5be0ac3659..8c8b56944ee 100644 --- a/doc/src/FAQ/TODO.html +++ b/doc/src/FAQ/TODO.html @@ -8,7 +8,7 @@

PostgreSQL TODO List

Current maintainer: Bruce Momjian (bruce@momjian.us)
-Last updated: Mon Sep 18 12:23:58 EDT 2006 +Last updated: Tue Sep 19 15:19:50 EDT 2006

The most recent version of this document can be viewed at
http://www.postgresql.org/docs/faqs.TODO.html. @@ -25,13 +25,7 @@ first.

Administration

  • Configuration files @@ -145,10 +132,6 @@ first. most recent transactions aren't available for recovery in case of a disk failure.

    -
  • -Automatically force archiving of partially-filled WAL files when - pg_stop_backup() is called or the server is stopped -
  • -Add reporting of the current WAL file and offset, perhaps as - part of partial log file archiving
  • %Create dump tool for write-ahead logs for use in determining transaction id for point-in-time recovery
  • Allow a warm standby system to also allow read-only statements @@ -166,8 +149,6 @@ first. a database for analysis.

  • %Add ability to monitor the use of temporary sort files -
  • -Allow server logs to be remotely read and removed using SQL commands -
  • -Allow protocol-level BIND parameter values to be logged

    • Data Types

    @@ -191,11 +172,6 @@ first.

    @@ -564,7 +506,6 @@ first.

    This requires the use of a savepoint before each COPY line is processed, with ROLLBACK on COPY failure.

    -
  • -Have COPY return the number of rows loaded/unloaded?
  • Allow COPY on a newly-created table to skip WAL logging

    On crash recovery, the table involved in the COPY would be removed or have its heap and index files truncated. One @@ -572,7 +513,6 @@ first. the table at the same time, which is something that is currently allowed.

    -
  • -Allow COPY (SELECT ...) TO 'filename'
  • GRANT/REVOKE
  • INSERT @@ -689,15 +623,13 @@ first.
  • Add PL/Python tracebacks

    http://archives.postgresql.org/pgsql-patches/2006-02/msg00288.php

    -
  • -Allow PL/python to return composite types and result sets

    • Clients

  • pg_dump
  • libpq
  • Wire Protocol Changes -- cgit v1.2.3