88< body bgcolor ="#FFFFFF "text ="#000000 "link ="#FF0000 "vlink ="#A00000 "alink ="#0000FF ">
99< h1 > < a name ="section_1 "> PostgreSQL TODO List</ a > </ h1 >
1010< p > Current maintainer: Bruce Momjian (< a href ="mailto:pgman@candle.pha.pa.us "> pgman@candle.pha.pa.us</ a > )< br />
11- Last updated: Thu Jun 811:41:16 EDT 2006
11+ Last updated: Thu Jun 812:07:13 EDT 2006
1212</ p >
1313< p > The most recent version of this document can be viewed at< br />
1414< a href ="http://www.postgresql.org/docs/faqs.TODO.html "> http://www.postgresql.org/docs/faqs.TODO.html</ a > .
@@ -142,7 +142,8 @@ <h1><a name="section_2">Administration</a></h1>
142142 pg_stop_backup() is called or the server is stopped
143143< p > Doing this will allow administrators to know more easily when
144144 the archive contains all the files needed for point-in-time
145- recovery. See< a href ="http://archives.postgresql.org/pgsql-patches/2005-04/msg00121.php "> http://archives.postgresql.org/pgsql-patches/2005-04/msg00121.php</ a > .
145+ recovery.
146+ < a href ="http://archives.postgresql.org/pgsql-patches/2005-04/msg00121.php "> http://archives.postgresql.org/pgsql-patches/2005-04/msg00121.php</ a >
146147</ p >
147148</ li > < li > %Create dump tool for write-ahead logs for use in determining
148149 transaction id for point-in-time recovery
@@ -329,8 +330,8 @@ <h1><a name="section_6">Multi-Language Support</a></h1>
329330 need to be reindexed to match the new locale.
330331</ p >
331332</ li > < li > Allow encoding on a per-column basis
332- < p > Right now only one encoding is allowed per database. For a partial
333- patch, see < a href ="http://archives.postgresql.org/pgsql-hackers/2005-03/msg00932.php "> http://archives.postgresql.org/pgsql-hackers/2005-03/msg00932.php</ a > .
333+ < p > Right now only one encoding is allowed per database.
334+ < a href ="http://archives.postgresql.org/pgsql-hackers/2005-03/msg00932.php "> http://archives.postgresql.org/pgsql-hackers/2005-03/msg00932.php</ a >
334335</ p >
335336</ li > < li > Support multiple simultaneous character sets, per SQL92
336337</ li > < li > Improve UTF8 combined character handling?
@@ -419,9 +420,8 @@ <h1><a name="section_8">SQL Commands</a></h1>
419420 The difficult of this features is allowing RESET ALL to not affect
420421 changes made by the interface driver for its internal use. One idea
421422 is for this to be a protocol-only feature. Another approach is to
422- notify the protocol when a RESET CONNECTION command is used. See
423+ notify the protocol when a RESET CONNECTION command is used.
423424< a href ="http://archives.postgresql.org/pgsql-patches/2006-04/msg00192.php "> http://archives.postgresql.org/pgsql-patches/2006-04/msg00192.php</ a >
424- for a partial implementation.
425425</ p >
426426</ li > < li > Add GUC to issue notice about statements that use unjoined tables
427427</ li > < li > Allow EXPLAIN to identify tables that were skipped because of
@@ -469,7 +469,7 @@ <h1><a name="section_8">SQL Commands</a></h1>
469469< li > %Have ALTER TABLE RENAME rename SERIAL sequence names
470470</ li > < li > Add ALTER DOMAIN to modify the underlying data type
471471</ li > < li > %Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME
472- < p > See < a href ="http://archives.postgresql.org/pgsql-patches/2006-02/msg00168.php "> http://archives.postgresql.org/pgsql-patches/2006-02/msg00168.php</ a > .
472+ < p > < a href ="http://archives.postgresql.org/pgsql-patches/2006-02/msg00168.php "> http://archives.postgresql.org/pgsql-patches/2006-02/msg00168.php</ a >
473473</ p >
474474</ li > < li > %Allow ALTER TABLE to change constraint deferrability and actions
475475</ li > < li > Add missing object types for ALTER ... SET SCHEMA
@@ -487,7 +487,7 @@ <h1><a name="section_8">SQL Commands</a></h1>
487487</ li > < li > Add ALTER TABLE tab ADD/DROP INHERITS parent
488488< p > This allows tables to be added/removed from an inheritance
489489 hierarchy. This is particularly useful for table partitioning.
490- See < a href ="http://archives.postgresql.org/pgsql-hackers/2006-05/msg00988.php "> http://archives.postgresql.org/pgsql-hackers/2006-05/msg00988.php</ a > .
490+ < a href ="http://archives.postgresql.org/pgsql-hackers/2006-05/msg00988.php "> http://archives.postgresql.org/pgsql-hackers/2006-05/msg00988.php</ a >
491491</ p >
492492</ li > < li > Have ALTER INDEX update the name of a constraint using that index
493493</ li > < li > Add ALTER TABLE RENAME CONSTRAINT, update index name also
@@ -741,7 +741,7 @@ <h1><a name="section_10">Triggers</a></h1>
741741</ p >
742742</ li > < li > Allow statement-level triggers to access modified rows
743743</ li > < li > Support triggers on columns
744- < p > See < a href ="http://archives.postgresql.org/pgsql-patches/2005-07/msg00107.php "> http://archives.postgresql.org/pgsql-patches/2005-07/msg00107.php</ a > .
744+ < p > < a href ="http://archives.postgresql.org/pgsql-patches/2005-07/msg00107.php "> http://archives.postgresql.org/pgsql-patches/2005-07/msg00107.php</ a >
745745</ p >
746746</ li > < li > Allow AFTER triggers on system tables
747747< p > System tables are modified in many places in the backend without going
@@ -791,7 +791,7 @@ <h1><a name="section_12">Exotic Features</a></h1>
791791</ li > </ ul >
792792</ li > < li > Consider allowing control of upper/lower case folding of unquoted
793793 identifiers
794- < p > Details at < a href ="http://archives.postgresql.org/pgsql-hackers/2004-04/msg00818.php "> http://archives.postgresql.org/pgsql-hackers/2004-04/msg00818.php</ a > .
794+ < p > < a href ="http://archives.postgresql.org/pgsql-hackers/2004-04/msg00818.php "> http://archives.postgresql.org/pgsql-hackers/2004-04/msg00818.php</ a >
795795</ p >
796796</ li > </ ul >
797797< h1 > < a name ="section_13 "> Indexes</ a > </ h1 >
@@ -1021,8 +1021,7 @@ <h1><a name="section_19">Write-Ahead Log</a></h1>
10211021</ li > < li > Allow the pg_xlog directory location to be specified during initdb
10221022 with a symlink back to the /data location
10231023</ li > < li > Allow WAL information to recover corrupted pg_controldata
1024- < p > See partially completed patch and additional work required at
1025- < a href ="http://archives.postgresql.org/pgsql-patches/2006-06/msg00025.php "> http://archives.postgresql.org/pgsql-patches/2006-06/msg00025.php</ a > .
1024+ < p > < a href ="http://archives.postgresql.org/pgsql-patches/2006-06/msg00025.php "> http://archives.postgresql.org/pgsql-patches/2006-06/msg00025.php</ a >
10261025</ p >
10271026</ li > < li > Find a way to reduce rotational delay when repeatedly writing
10281027 last WAL page
@@ -1167,7 +1166,7 @@ <h1><a name="section_22">Source Code</a></h1>
11671166< p > This involves choosing better pivot points for the quicksort.
11681167</ p >
11691168</ li > < li > Consider GnuTLS if OpenSSL license becomes a problem
1170- < p > See < a href ="http://archives.postgresql.org/pgsql-patches/2006-05/msg00040.php "> http://archives.postgresql.org/pgsql-patches/2006-05/msg00040.php</ a > .
1169+ < p > < a href ="http://archives.postgresql.org/pgsql-patches/2006-05/msg00040.php "> http://archives.postgresql.org/pgsql-patches/2006-05/msg00040.php</ a >
11711170</ p >
11721171</ li > < li > Win32
11731172< ul >
@@ -1181,8 +1180,9 @@ <h1><a name="section_22">Source Code</a></h1>
11811180</ li > < li > Re-enable timezone output on log_line_prefix '%t' when a
11821181 shorter timezone string is available
11831182</ li > < li > Fix problem with shared memory on the Win32 Terminal Server
1184- </ li > < li > Improve signal handling,
1185- < a href ="http://archives.postgresql.org/pgsql-patches/2005-06/msg00027.php "> http://archives.postgresql.org/pgsql-patches/2005-06/msg00027.php</ a >
1183+ </ li > < li > Improve signal handling
1184+ < p > < a href ="http://archives.postgresql.org/pgsql-patches/2005-06/msg00027.php "> http://archives.postgresql.org/pgsql-patches/2005-06/msg00027.php</ a >
1185+ </ p >
11861186</ li > < li > Add long file support for binary pg_dump output
11871187< p > While Win32 supports 64-bit files, the MinGW API does not,
11881188 meaning we have to build an fseeko replacement on top of the