From ee2b61ee55bb866acf5a303adce7e8f8dd40c1d9 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Wed, 24 Aug 2005 14:05:37 +0000 Subject: Mark "easy" items. Jim C. Nasby --- doc/src/FAQ/TODO.html | 100 +++++++++++++++++++++++++------------------------- 1 file changed, 51 insertions(+), 49 deletions(-) (limited to 'doc/src') diff --git a/doc/src/FAQ/TODO.html b/doc/src/FAQ/TODO.html index 707addbba9e..a0fc82fa72d 100644 --- a/doc/src/FAQ/TODO.html +++ b/doc/src/FAQ/TODO.html @@ -8,12 +8,13 @@

PostgreSQL TODO List

Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
-Last updated: Wed Aug 24 10:00:31 EDT 2005 +Last updated: Wed Aug 24 10:05:23 EDT 2005

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

A hyphen, "-", marks changes that will appear in the upcoming 8.1 release. +

A hyphen, "-", marks changes that will appear in the upcoming 8.1 release.
+A percent sign, "%", marks items that are easier to implement.

Bracketed items, "[]", have more detail.

@@ -24,10 +25,10 @@ first.

Administration

Remove behavior of postmaster -o after making postmaster/postgres +
%Remove behavior of postmaster -o after making postmaster/postgres flags unique
-Allow limits on per-db/role connections -
Allow pooled connections to list all prepared queries +
%Allow pooled connections to list all prepared queries
This would allow an application inheriting a pooled connection to know the queries prepared in the current session.
@@ -40,7 +41,7 @@ first.
Currently SIGTERM of a backend can lead to lock table corruption.
-Prevent dropping user that still owns objects, or auto-drop the objects -
Set proper permissions on non-system schemas during db creation +
%Set proper permissions on non-system schemas during db creation
Currently all schemas are owned by the super-user because they are copied from the template1 database.
@@ -59,22 +60,22 @@ first.

Configuration files

Add "include file" functionality in postgresql.conf +
%Add "include file" functionality in postgresql.conf
Allow postgresql.conf values to be set so they can not be changed by the user -
Allow commenting of variables in postgresql.conf to restore them +
%Allow commenting of variables in postgresql.conf to restore them to defaults
Currently, if a variable is commented out, it keeps the previous uncommented value until a server restarted.
-
Allow pg_hba.conf settings to be controlled via SQL +
%Allow pg_hba.conf settings to be controlled via SQL
This would add a function to load the SQL table from pg_hba.conf, and one to writes its contents to the flat file. The table should have a line number that is a float so rows can be inserted between existing rows, e.g. row 2.5 goes between row 2 and row 3.
-
Allow postgresql.conf file values to be changed via an SQL +
%Allow postgresql.conf file values to be changed via an SQL API, perhaps using SET GLOBAL
Allow the server to be stopped/restarted via an SQL API

@@ -100,7 +101,7 @@ first. database to find the objects in each database for that tablespace.

Add a GUC variable to control the tablespace for temporary objects +
%Add a GUC variable to control the tablespace for temporary objects and sort files
It could start with a random tablespace from a supplied list and cycle through the list. @@ -125,7 +126,7 @@ first. the archive contins all the files needed for point-in-time recovery.
-
Create dump tool for write-ahead logs for use in determining +
%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 queries [pitr] @@ -141,7 +142,7 @@ first.
This would allow server log information to be easily loaded into a database for analysis.
-
Add ability to monitor the use of temporary sort files +
%Add ability to monitor the use of temporary sort files
-Add session start time and last statement time to pg_stat_activity
-Add a function that returns the start time of the postmaster
Allow server logs to be remotely read and removed using SQL commands @@ -149,7 +150,7 @@ first.
Data Types
- Remove Money type, add money formatting for decimal type +
- %Remove Money type, add money formatting for decimal type
- Change NUMERIC to enforce the maximum precision, and increase it
- Add NUMERIC division operator that doesn't round?
  Currently NUMERIC _rounds_ the result to the specified precision. @@ -165,14 +166,14 @@ first.
  - Have sequence dependency track use of DEFAULT sequences, seqname.nextval? -
  - Disallow changing default expression of a SERIAL column? +
  - %Disallow changing default expression of a SERIAL column?
  - Fix data types where equality comparison isn't intuitive, e.g. box -
  - Prevent INET cast to CIDR if the unmasked bits are not zero, or +
  - %Prevent INET cast to CIDR if the unmasked bits are not zero, or zero the bits -
  - Prevent INET cast to CIDR from droping netmask, SELECT '1.1.1.1'::inet::cidr +
  - %Prevent INET cast to CIDR from droping netmask, SELECT '1.1.1.1'::inet::cidr
  - Allow INET + INT4 to increment the host part of the address, or throw an error on overflow -
  - Add 'tid != tid ' operator for use in corruption recovery +
  - %Add 'tid != tid ' operator for use in corruption recovery
  - Dates and Times
    - Allow infinite dates just like infinite timestamps @@ -207,7 +208,7 @@ first.
    - Arrays
      - Allow NULLs in arrays -
      - Allow MIN()/MAX() on arrays +
      - %Allow MIN()/MAX() on arrays
      - Delay resolution of array expression's data type so assignment coercion can be performed on empty array expressions
      - Modify array literal representation to handle array index lower bound @@ -238,7 +239,7 @@ first. make time reporting more consistent and will allow reporting of the statement start time.
        -
      - Add pg_get_acldef(), pg_get_typedefault(), and pg_get_attrdef() +
      - %Add pg_get_acldef(), pg_get_typedefault(), and pg_get_attrdef()
      - Allow to_char() to print localized month names
      - Allow functions to have a schema search path specified at creation time
      - Allow substring/replace() to get/set bit values @@ -283,15 +284,15 @@ first.
        Views / Rules
        
        -
        Automatically create rules on views so they are updateable, per SQL99 +
        %Automatically create rules on views so they are updateable, per SQL99
        We can only auto-create rules for simple views. For more complex cases users will still have to write rules.
        
        Add the functionality for WITH CHECK OPTION clause of CREATE VIEW
        Allow NOTIFY in rules involving conditionals -
        Have views on temporary tables exist in the temporary namespace +
        %Have views on temporary tables exist in the temporary namespace
        Allow temporary views on non-temporary tables -
        Allow RULE recompilation +
        %Allow RULE recompilation
        
        SQL Commands
        @@ -308,9 +309,9 @@ first.
      - Add CORRESPONDING BY to UNION/INTERSECT/EXCEPT
      - -Allow REINDEX to rebuild all database indexes
      - Add ROLLUP, CUBE, GROUPING SETS options to GROUP BY -
      - Allow SET CONSTRAINTS to be qualified by schema/table name -
      - Allow TRUNCATE ... CASCADE/RESTRICT -
      - Add a separate TRUNCATE permission +
      - %Allow SET CONSTRAINTS to be qualified by schema/table name +
      - %Allow TRUNCATE ... CASCADE/RESTRICT +
      - %Add a separate TRUNCATE permission
        Currently only the owner can TRUNCATE a table because triggers are not called, and the table is locked in exclusive mode.
        @@ -338,7 +339,7 @@ first. triggers?)
      - Add NOVICE output level for helpful messages like automatic sequence/index creation -
      - Add COMMENT ON for all cluster global objects (roles, databases +
      - %Add COMMENT ON for all cluster global objects (roles, databases and tablespaces)
      - -Add an option to automatically use savepoints for each statement in a multi-statement transaction. @@ -383,11 +384,11 @@ first.
    - ALTER
      - Have ALTER TABLE RENAME rename SERIAL sequence names -
      - Add ALTER DOMAIN TYPE -
      - Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME -
      - Allow ALTER TABLE to change constraint deferrability and actions -
      - Disallow dropping of an inherited constraint +
      - %Have ALTER TABLE RENAME rename SERIAL sequence names +
      - %Add ALTER DOMAIN TYPE +
      - %Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME +
      - %Allow ALTER TABLE to change constraint deferrability and actions +
      - %Disallow dropping of an inherited constraint
      - -Allow objects to be moved to different schemas
      - Allow ALTER TABLESPACE to move to different directories
      - Allow databases to be moved to different tablespaces @@ -395,7 +396,7 @@ first.
        Currently non-global system tables must be in the default database tablespace. Global system tables can never be moved.
        -
      - Prevent child tables from altering constraints like CHECK that were +
      - %Prevent child tables from altering constraints like CHECK that were inherited from the parent table
    - CLUSTER @@ -409,7 +410,7 @@ first. store heap rows in hashed groups, perhaps using a user-supplied hash function.
      -
    - Add default clustering to system tables +
    - %Add default clustering to system tables
      To do this, determine the ideal cluster index for each system table and set the cluster setting during initdb.
      @@ -421,7 +422,7 @@ first. processed, with ROLLBACK on COPY failure.
    - -Allow COPY to understand \x as a hex byte -
    - Have COPY return the number of rows loaded/unloaded? +
    - %Have COPY return the number of rows loaded/unloaded?
    - -Allow COPY to optionally include column headings in the first line
    - -Allow COPY FROM ... CSV to interpret newlines and carriage returns in data @@ -429,7 +430,7 @@ first.
    - GRANT/REVOKE
      - Allow column-level privileges -
      - Allow GRANT/REVOKE permissions to be applied to all schema objects +
      - %Allow GRANT/REVOKE permissions to be applied to all schema objects with one command
        The proposed syntax is:
        GRANT SELECT ON ALL TABLES IN public TO phpuser; @@ -450,7 +451,7 @@ first.
      - Prevent DROP TABLE from dropping a row referenced by its own open cursor? -
      - Allow pooled connections to list all open WITH HOLD cursors +
      - %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.
        @@ -534,21 +535,21 @@ first.
    - pg_dump
      - Have pg_dump use multi-statement transactions for INSERT dumps -
      - Allow pg_dump to use multiple -t and -n switches [pg_dump] -
      - Add dumping of comments on composite type columns -
      - Add dumping of comments on index columns -
      - Replace crude DELETE FROM method of pg_dumpall --clean for +
      - %Have pg_dump use multi-statement transactions for INSERT dumps +
      - %Allow pg_dump to use multiple -t and -n switches [pg_dump] +
      - %Add dumping of comments on composite type columns +
      - %Add dumping of comments on index columns +
      - %Replace crude DELETE FROM method of pg_dumpall --clean for cleaning of roles with separate DROP commands
      - -Add dumping and restoring of LOB comments
      - Stop dumping CASCADE on DROP TYPE commands in clean mode -
      - Add full object name to the tag field. eg. for operators we need +
      - %Add full object name to the tag field. eg. for operators we need '=(integer, integer)', instead of just '='.
      - Add pg_dumpall custom format dumps.
        This is probably best done by combining pg_dump and pg_dumpall into a single binary.
        -
      - Add CSV output format +
      - %Add CSV output format
      - Update pg_dump and psql to use the new COPY libpq API (Christopher)
      - Remove unnecessary abstractions in pg_dump source code
      @@ -564,7 +565,7 @@ first.
    - Use backend PREPARE/EXECUTE facility for ecpg where possible
    - Implement SQLDA
    - Fix nested C comments -
    - sqlwarn[6] should be 'W' if the PRECISION or SCALE value specified +
    - %sqlwarn[6] should be 'W' if the PRECISION or SCALE value specified
    - Make SET CONNECTION thread-aware, non-standard?
    - Allow multidimensional arrays
    - Add internationalized message strings @@ -596,7 +597,7 @@ first.
    - Allow statement-level triggers to access modified rows
    - Support triggers on columns (Greg Sabino Mullane) -
    - Remove CREATE CONSTRAINT TRIGGER +
    - %Remove CREATE CONSTRAINT TRIGGER
      This was used in older releases to dump referential integrity constraints.
      @@ -728,7 +729,7 @@ first.
    - Improve commit_delay handling to reduce fsync()
    - Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options
    - -Allow multiple blocks to be written to WAL with one write() -
    - Add an option to sync() before fsync()'ing checkpoint files +
    - %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
    @@ -813,12 +814,12 @@ first. VACUUM can look at just those pages rather than the entire table. In the event of a system crash, the bitmap would probably be invalidated.
    -
  - Add system view to show free space map contents +
  - %Add system view to show free space map contents
  - Auto-vacuum
    - -Move into the backend code
    - Use free-space map information to guide refilling -
    - Suggest VACUUM FULL if a table is nearly empty +
    - %Suggest VACUUM FULL if a table is nearly empty
    - Improve xid wraparound detection by recording per-table rather than per-database
    @@ -967,7 +968,7 @@ first.
  - Rename some /contrib modules from pg* to pg_*
  - Move some things from /contrib into main tree
  - Move some /contrib modules out to their own project sites -
  - Remove warnings created by -Wcast-align +
  - %Remove warnings created by -Wcast-align
  - Move platform-specific ps status display info from ps_status.c to ports
  - Add optional CRC checksum to heap and index pages
  - Improve documentation to build only interfaces (Marc) @@ -996,6 +997,7 @@ first.
  - Fix cross-compiling of time zone database via 'zic'
  - Fix sgmltools so PDFs can be generated with bookmarks
  - -Add C code on Unix to copy directories for use in creating new databases +
  - %Clean up compiler warnings (especially with gcc version 4)
  - Win32
    - Remove configure.in check for link failure when cause is found -- cgit v1.2.3

PostgreSQL TODO List

Administration

Data Types

Views / Rules

SQL Commands

Cache Usage