From fca7bcbb649a756621248b95d02d72ca4ebccc9b Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 6 Mar 2008 03:15:52 +0000 Subject: Break out referential integrity and server-side languages into separate TODO categories. --- doc/src/FAQ/TODO.html | 151 +++++++++++++++++++++++++------------------------- 1 file changed, 76 insertions(+), 75 deletions(-) (limited to 'doc/src') diff --git a/doc/src/FAQ/TODO.html b/doc/src/FAQ/TODO.html index 7e520f6a7e7..b38becbc191 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: Wed Mar 5 11:07:13 EST 2008 +Last updated: Wed Mar 5 22:15:29 EST 2008

The most recent version of this document can be viewed at
http://www.postgresql.org/docs/faqs.TODO.html. @@ -623,74 +623,75 @@ first. There is also a developer's wiki at

Add SET PERFORMANCE_TIPS option to suggest INDEX, VACUUM, VACUUM ANALYZE, and CLUSTER

Referential Integrity +

Referential Integrity

+ +

Add MATCH PARTIAL referential integrity +
Change foreign key constraint for array -> element to mean element + in array? +
Fix problem when cascading referential triggers make changes on + cascaded tables, seeing the tables in an intermediate state +
http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php + http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php +
+
Allow DEFERRABLE and end-of-statement UNIQUE constraints? +
This would allow UPDATE tab SET col = col + 1 to work if col has + a unique index. Currently, uniqueness checks are done while the + command is being executed, rather than at the end of the statement + or transaction. + http://people.planetpostgresql.org/greg/index.php?/archives/2006/06/10.html + http://archives.postgresql.org/pgsql-hackers/2006-09/msg01458.php +
+

Server-Side Languages

+ +

PL/pgSQL
- Add MATCH PARTIAL referential integrity -
- Change foreign key constraint for array -> element to mean element - in array? -
- Fix problem when cascading referential triggers make changes on - cascaded tables, seeing the tables in an intermediate state -
  http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php - http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php -
  -
- Allow DEFERRABLE and end-of-statement UNIQUE constraints? -
  This would allow UPDATE tab SET col = col + 1 to work if col has - a unique index. Currently, uniqueness checks are done while the - command is being executed, rather than at the end of the statement - or transaction. -
  -
  http://people.planetpostgresql.org/greg/index.php?/archives/2006/06/10.html - http://archives.postgresql.org/pgsql-hackers/2006-09/msg01458.php +
- Fix RENAME to work on variables other than OLD/NEW +
  http://archives.postgresql.org/pgsql-hackers/2002-03/msg00591.php + http://archives.postgresql.org/pgsql-hackers/2007-01/msg01615.php + http://archives.postgresql.org/pgsql-hackers/2007-01/msg01587.php +
  +
- Allow function parameters to be passed by name, + get_employee_salary(12345 AS emp_id, 2001 AS tax_year) +
- Allow handling of %TYPE arrays, e.g. tab.col%TYPE[] +
- Allow listing of record column names, and access to + record columns via variables, e.g. columns := r.(*), + tval2 := r.(colname) +
  http://archives.postgresql.org/pgsql-patches/2005-07/msg00458.php + http://archives.postgresql.org/pgsql-patches/2006-05/msg00302.php + http://archives.postgresql.org/pgsql-patches/2006-06/msg00031.php +
  +
- Add support for SCROLL cursors +
- Add support for WITH HOLD cursors +
- Allow row and record variables to be set to NULL constants, + and allow NULL tests on such variables +
  Because a row is not scalar, do not allow assignment + from NULL-valued scalars. +
  +
  http://archives.postgresql.org/pgsql-hackers/2006-10/msg00070.php
-
Server-Side Languages +
Other
- PL/pgSQL -
  - Fix RENAME to work on variables other than OLD/NEW -
    http://archives.postgresql.org/pgsql-hackers/2002-03/msg00591.php - http://archives.postgresql.org/pgsql-hackers/2007-01/msg01615.php - http://archives.postgresql.org/pgsql-hackers/2007-01/msg01587.php -
    -
  - Allow function parameters to be passed by name, - get_employee_salary(12345 AS emp_id, 2001 AS tax_year) -
  - Allow handling of %TYPE arrays, e.g. tab.col%TYPE[] -
  - Allow listing of record column names, and access to - record columns via variables, e.g. columns := r.(*), - tval2 := r.(colname) -
    http://archives.postgresql.org/pgsql-patches/2005-07/msg00458.php - http://archives.postgresql.org/pgsql-patches/2006-05/msg00302.php - http://archives.postgresql.org/pgsql-patches/2006-06/msg00031.php -
    -
  - Add support for SCROLL cursors -
  - Add support for WITH HOLD cursors -
  - Allow row and record variables to be set to NULL constants, - and allow NULL tests on such variables -
    Because a row is not scalar, do not allow assignment - from NULL-valued scalars. -
    -
    http://archives.postgresql.org/pgsql-hackers/2006-10/msg00070.php -
    -
  -
- Other -
  - Add table function support to pltcl, plpythonu -
  - Add support for polymorphic arguments and return types to - languages other than PL/PgSQL -
  - Add capability to create and call PROCEDURES -
  - Add support for OUT and INOUT parameters to languages other - than PL/PgSQL -
  - Add PL/PythonU tracebacks -
    http://archives.postgresql.org/pgsql-patches/2006-02/msg00288.php -
    -
  - Allow data to be passed in native language formats, rather - than only text -
    http://archives.postgresql.org/pgsql-hackers/2007-05/msg00289.php +
  - Add table function support to pltcl, plpythonu +
  - Add support for polymorphic arguments and return types to + languages other than PL/PgSQL +
  - Add capability to create and call PROCEDURES +
  - Add support for OUT and INOUT parameters to languages other + than PL/PgSQL +
  - Add PL/PythonU tracebacks +
    http://archives.postgresql.org/pgsql-patches/2006-02/msg00288.php +
    +
  - Allow data to be passed in native language formats, rather + than only text +
    http://archives.postgresql.org/pgsql-hackers/2007-05/msg00289.php
    -

Clients

Have pg_ctl look at PGHOST in case it is a socket directory? @@ -821,7 +822,7 @@ first. There is also a developer's wiki at

Triggers

Add deferred trigger queue file @@ -859,7 +860,7 @@ first. There is also a developer's wiki at

http://archives.postgresql.org/pgsql-sql/2008-01/msg00050.php

Indexes

Add UNIQUE capability to non-btree indexes @@ -931,7 +932,7 @@ first. There is also a developer's wiki at

http://archives.postgresql.org/pgsql-hackers/2007-03/msg01199.php

Fsync

Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options @@ -941,7 +942,7 @@ first. There is also a developer's wiki at
Add program to test if fsync has a delay compared to non-fsync

Cache Usage

Speed up COUNT(*) @@ -994,7 +995,7 @@ first. There is also a developer's wiki at
http://archives.postgresql.org/pgsql-hackers/2007-01/msg00752.php

Vacuum

Improve speed with indexes @@ -1045,7 +1046,7 @@ first. There is also a developer's wiki at

Locking

Fix priority ordering of read and write light-weight locks (Neil) @@ -1071,7 +1072,7 @@ first. There is also a developer's wiki at
http://archives.postgresql.org/pgsql-committers/2008-01/msg00365.php

Startup Time Improvements

Experiment with multi-threaded backend for backend creation [thread] @@ -1082,7 +1083,7 @@ first. There is also a developer's wiki at
a single session using multiple threads to execute a statement faster.

Write-Ahead Log

Eliminate need to write full pages to WAL before page modification [wal] @@ -1143,7 +1144,7 @@ first. There is also a developer's wiki at
http://archives.postgresql.org/pgsql-hackers/2008-02/msg01279.php

Optimizer / Executor

Improve selectivity functions for geometric operators @@ -1166,7 +1167,7 @@ first. There is also a developer's wiki at

http://archives.postgresql.org/pgsql-hackers/2007-01/msg00096.php

Miscellaneous Performance

Do async I/O for faster random read-ahead of data @@ -1219,7 +1220,7 @@ first. There is also a developer's wiki at
concurrent reads from multiple devices in a partitioned table.

Source Code

Add use of 'const' for variables in source tree @@ -1286,7 +1287,7 @@ first. There is also a developer's wiki at
of result sets using new statement protocol

Exotic Features

Add pre-parsing phase that converts non-ISO syntax to supported @@ -1313,7 +1314,7 @@ first. There is also a developer's wiki at

http://archives.postgresql.org/pgsql-hackers/2008-01/msg00893.php

Features We Do Not Want

All backends running as threads in a single process (not wanted) -- cgit v1.2.3