From de5d30069b6fbe1a513fa8bfcd97ee2b77862142 Mon Sep 17 00:00:00 2001
From: Bruce Momjian
Date: Mon, 4 Jul 2005 17:43:42 +0000
Subject: More TODO list section restructuring.
---
doc/src/FAQ/TODO.html | 177 +++++++++++++++++++++++++++-----------------------
1 file changed, 97 insertions(+), 80 deletions(-)
(limited to 'doc/src')
diff --git a/doc/src/FAQ/TODO.html b/doc/src/FAQ/TODO.html
index 7f1546e9c4a..c0725581af4 100644
--- a/doc/src/FAQ/TODO.html
+++ b/doc/src/FAQ/TODO.html
@@ -8,7 +8,7 @@
Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
-Last updated: Mon Jul 4 13:00:23 EDT 2005
+Last updated: Mon Jul 4 13:43:32 EDT 2005
The most recent version of this document can be viewed at
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -101,7 +101,7 @@ first.
Allow per-tablespace quotas
- Point-in-time Recovery (PITR)
+ Point-In-Time Recovery (PITR)
- Allow point-in-time recovery to archive partially filled
write-ahead logs [pitr]
@@ -157,42 +157,47 @@ first.
- Have sequence dependency track use of DEFAULT sequences,
seqname.nextval?
- Disallow changing default expression of a SERIAL column?
-
- Allow infinite dates just like infinite timestamps
-
- Add a GUC variable to allow output of interval values in ISO8601 format
- Fix data types where equality comparison isn't intuitive, e.g. box
-
- Merge hardwired timezone names with the TZ database; allow either kind
- everywhere a TZ name is currently taken
-
- Allow customization of the known set of TZ names (generalize the
- present australian_timezones hack)
-
- Allow TIMESTAMP WITH TIME ZONE to store the original timezone
- information, either zone name or offset from UTC [timezone]
-
If the TIMESTAMP value is stored with a time zone name, interval
- computations should adjust based on the time zone rules, e.g. adding
- 24 hours to a timestamp would yield a different result from adding one
- day.
-
- 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
- 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 ISO INTERVAL handling
+
- Dates and Times
- - Add support for day-time syntax, INTERVAL '1 2:03:04' DAY TO SECOND
-
- Add support for year-month syntax, INTERVAL '50-6' YEAR TO MONTH
-
- For syntax that isn't uniquely ISO or PG syntax, like '1:30' or
- '1', treat as ISO if there is a range specification clause,
- and as PG if there no clause is present, e.g. interpret '1:30'
- MINUTE TO SECOND as '1 minute 30 seconds', and interpret '1:30'
- as '1 hour, 30 minutes'
-
- Interpret INTERVAL '1 year' MONTH as CAST (INTERVAL '1 year' AS
- INTERVAL MONTH), and this should return '12 months'
-
- Round or truncate values to the requested precision, e.g.
- INTERVAL '11 months' AS YEAR should return one or zero
-
- Support precision, CREATE TABLE foo (a INTERVAL MONTH(3))
-
- - ARRAYS
+
- Allow infinite dates just like infinite timestamps
+
- Add a GUC variable to allow output of interval values in ISO8601
+ format
+
- Merge hardwired timezone names with the TZ database; allow either
+ kind everywhere a TZ name is currently taken
+
- Allow customization of the known set of TZ names (generalize the
+ present australian_timezones hack)
+
- Allow TIMESTAMP WITH TIME ZONE to store the original timezone
+ information, either zone name or offset from UTC [timezone]
+
If the TIMESTAMP value is stored with a time zone name, interval
+ computations should adjust based on the time zone rules, e.g.
+ adding 24 hours to a timestamp would yield a different result from
+ adding one day.
+
+ - Add ISO INTERVAL handling
+
+
+ Arrays
- Allow NULLs in arrays
- Allow MIN()/MAX() on arrays
@@ -201,7 +206,7 @@ first.
- Modify array literal representation to handle array index lower bound
of other than one
- BINARY DATA
+ Binary Data
- Improve vacuum of large objects, like /contrib/vacuumlo?
- Add security checking for large objects
@@ -280,30 +285,21 @@ first.
- Allow temporary views on non-temporary tables
- Allow RULE recompilation
-
+
- -Add BETWEEN SYMMETRIC/ASYMMETRIC
- Change LIMIT/OFFSET and FETCH/MOVE to use int8
-
- Allow CREATE TABLE AS to determine column lengths for complex
- expressions like SELECT col1 || col2
-
- Allow UPDATE to handle complex aggregates [update]?
- -Add E'' escape string marker so eventually ordinary strings can treat
backslashes literally, for portability
-
- Allow an alias to be provided for the target table in UPDATE/DELETE
-
This is not SQL-spec but many DBMSs allow it.
-
- -Allow additional tables to be specified in DELETE for joins
UPDATE already allows this (UPDATE...FROM) but we need similar
functionality in DELETE. It's been agreed that the keyword should
be USING, to avoid anything as confusing as DELETE FROM a FROM b.
- - Have initdb set DateStyle based on locale?
- Add CORRESPONDING BY to UNION/INTERSECT/EXCEPT
- -Allow REINDEX to rebuild all database indexes
- Add ROLLUP, CUBE, GROUPING SETS options to GROUP BY
-
- Add a schema option to createlang
-
- Allow UPDATE tab SET ROW (col, ...) = (...) for updating multiple columns
- Allow SET CONSTRAINTS to be qualified by schema/table name
- Allow TRUNCATE ... CASCADE/RESTRICT
- Allow PREPARE of cursors
@@ -324,25 +320,10 @@ first.
This would allow an informational message to be added to the notify
message, perhaps indicating the row modified or other custom
information.
-
- - Use more reliable method for CREATE DATABASE to get a consistent copy
- of db?
-
Currently the system uses the operating system COPY command to create
- a new database.
-
- - Add C code on Unix to copy directories for use in creating new databases
-
- Have pg_ctl look at PGHOST in case it is a socket directory?
-
- Allow pg_ctl to work properly with configuration files located outside
- the PGDATA directory
-
pg_ctl can not read the pid file because it isn't located in the
- config directory but in the PGDATA directory. The solution is to
- allow pg_ctl to read and understand postgresql.conf to find the
- data_directory value.
- Add a GUC variable to warn about non-standard SQL usage in queries
- Add MERGE command that does UPDATE/DELETE, or on failure, INSERT (rules,
triggers?)
-
- Add ON COMMIT capability to CREATE TABLE AS SELECT
- Add NOVICE output level for helpful messages like automatic sequence/index
creation
- Add COMMENT ON for all cluster global objects (roles, databases
@@ -363,8 +344,28 @@ first.
is for this to be a protocol-only feature. Another approach is to
notify the protocol when a RESET CONNECTION command is used.
-
- Allow FOR UPDATE queries to do NOWAIT locks
- Add GUC to issue notice about queries that use unjoined tables
+
- CREATE
+
+ - Allow CREATE TABLE AS to determine column lengths for complex
+ expressions like SELECT col1 || col2
+
- Use more reliable method for CREATE DATABASE to get a consistent
+ copy of db?
+
- Currently the system uses the operating system COPY command to
+ create a new database. Add ON COMMIT capability to CREATE TABLE AS
+ SELECT
+
+ - UPDATE
+
- ALTER
-
- SERVER-SIDE LANGUAGES
+
- Server-Side Languages
- -Allow PL/PgSQL's RAISE function to take expressions
Currently only constants are supported.
@@ -491,16 +492,30 @@ first.
- Allow libpq to access SQLSTATE so pg_ctl can test for connection failure
This would be used for checking if the server is up.
- - Have psql show current values for a sequence
-
- Move psql backslash database information into the backend, use mnemonic
- commands? [psql]
-
This would allow non-psql clients to pull the same information out of
- the database as psql.
+
- Have initdb set DateStyle based on locale?
+
- Have pg_ctl look at PGHOST in case it is a socket directory?
+
- Add a schema option to createlang
+
- Allow pg_ctl to work properly with configuration files located outside
+ the PGDATA directory
+
pg_ctl can not read the pid file because it isn't located in the
+ config directory but in the PGDATA directory. The solution is to
+ allow pg_ctl to read and understand postgresql.conf to find the
+ data_directory value.
- - Fix psql's display of schema information (Neil)
-
- Allow psql \pset boolean variables to set to fixed values, rather than toggle
-
- Consistently display privilege information for all objects in psql
-
- Improve psql's handling of multi-line queries
+
- psql
+
- pg_dump
- Have pg_dump use multi-statement transactions for INSERT dumps
@@ -520,7 +535,7 @@ first.
- Add CSV output format
- Update pg_dump and psql to use the new COPY libpq API (Christopher)
- - ECPG
+
- ecpg
- Docs
Document differences between ecpg and the SQL standard and
@@ -548,7 +563,6 @@ first.
This item involves dumping large queues into files.
- -Implement shared row locks and use them in RI triggers
-
- Enforce referential integrity for system tables
- Change foreign key constraint for array -> element to mean element
in array?
- Allow DEFERRABLE UNIQUE constraints?
@@ -566,6 +580,7 @@ first.
This was used in older releases to dump referential integrity
constraints.
+ - Enforce referential integrity for system tables
- Allow AFTER triggers on system tables
System tables are modified in many places in the backend without going
through the executor and therefore not causing triggers to fire. To
@@ -594,9 +609,7 @@ first.
to clients
- Allow queries across databases or servers with transaction
semantics
-
Right now contrib/dblink can be used to issue such queries except it
- does not have locking or transaction semantics. Two-phase commit is
- needed to enable transaction semantics.
+
This can be done using dblink and two-phase commit.
- -Add two-phase commit
- Add the features of packages
@@ -619,7 +632,6 @@ first.
that can span more than one table.
- Add UNIQUE capability to non-btree indexes
-
- Add more GIST index support for geometric data types
- -Use indexes for MIN() and MAX()
MIN/MAX queries can already be rewritten as SELECT col FROM tab ORDER
BY col {DESC} LIMIT 1. Completing this item involves doing this
@@ -659,15 +671,19 @@ first.
- Allow use of indexes to search for NULLs
One solution is to create a partial index on an IS NULL expression.
- - -Add concurrency to GIST
- Allow accurate statistics to be collected on indexes with more than
one column or expression indexes, perhaps using per-index statistics
- Add fillfactor to control reserved free space during index creation
- Allow the creation of indexes with mixed ascending/descending specifiers
- -Fix incorrect rtree results due to wrong assumptions about "over"
operator semantics
-
- Allow GIST indexes to create certain complex index types, like digital
- trees (see Aoki)
+
- GIST
+
+ - Add more GIST index support for geometric data types
+
- -Add concurrency to GIST
+
- Allow GIST indexes to create certain complex index types, like
+ digital trees (see Aoki)
+
- Hash
- Pack hash index buckets onto disk pages more efficiently
@@ -782,7 +798,7 @@ first.
@@ -867,7 +883,7 @@ first.
- Create utility to compute accurate random_page_cost value
- Improve ability to display optimizer analysis using OPTIMIZER_DEBUG
- Have EXPLAIN ANALYZE highlight poor optimizer estimates
-
- Use CHECK constraints to influence optimizer decisions
+
- -Use CHECK constraints to influence optimizer decisions
CHECK constraints contain information about the distribution of values
within the table. This is also useful for implementing subtables where
a tables content is distributed across several subtables.
@@ -938,6 +954,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
- Win32
- Remove configure.in check for link failure when cause is found
@@ -999,6 +1016,6 @@ first.
- Tatsuo is Tatsuo Ishii <t-ishii@sra.co.jp> of Software Research Assoc.
- Tom is Tom Lane <tgl@sss.pgh.pa.us> of Red Hat
-
+