Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitfca7bcb

Browse files
committed
Break out referential integrity and server-side languages into separate
TODO categories.
1 parent4d436ef commitfca7bcb

File tree

2 files changed

+128
-125
lines changed

2 files changed

+128
-125
lines changed

‎doc/TODO

Lines changed: 52 additions & 50 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
PostgreSQL TODO List
22
====================
33
Current maintainer:Bruce Momjian (bruce@momjian.us)
4-
Last updated:Wed Mar 511:07:13 EST 2008
4+
Last updated:Wed Mar 522:15:29 EST 2008
55

66
The most recent version of this document can be viewed at
77
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -711,73 +711,75 @@ SQL Commands
711711
ANALYZE, and CLUSTER
712712

713713

714-
* Referential Integrity
715714

716-
o Add MATCH PARTIAL referential integrity
717-
o Change foreign key constraint for array -> element to mean element
718-
in array?
719-
o Fix problem when cascading referential triggers make changes on
720-
cascaded tables, seeing the tables in an intermediate state
715+
Referential Integrity
716+
=====================
721717

722-
http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php
723-
http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php
718+
* Add MATCH PARTIAL referential integrity
719+
* Change foreign key constraint for array -> element to mean element
720+
in array?
721+
* Fix problem when cascading referential triggers make changes on
722+
cascaded tables, seeing the tables in an intermediate state
724723

725-
o Allow DEFERRABLE and end-of-statement UNIQUE constraints?
724+
http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php
725+
http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php
726726

727-
This would allow UPDATE tab SET col = col + 1 to work if col has
728-
a unique index. Currently, uniqueness checks are done while the
729-
command is being executed, rather than at the end of the statement
730-
or transaction.
727+
* Allow DEFERRABLE and end-of-statement UNIQUE constraints?
731728

732-
http://people.planetpostgresql.org/greg/index.php?/archives/2006/06/10.html
733-
http://archives.postgresql.org/pgsql-hackers/2006-09/msg01458.php
729+
This would allow UPDATE tab SET col = col + 1 to work if col has
730+
a unique index. Currently, uniqueness checks are done while the
731+
command is being executed, rather than at the end of the statement
732+
or transaction.
733+
http://people.planetpostgresql.org/greg/index.php?/archives/2006/06/10.html
734+
http://archives.postgresql.org/pgsql-hackers/2006-09/msg01458.php
734735

735736

736-
* Server-Side Languages
737+
Server-Side Languages
738+
=====================
737739

738-
o PL/pgSQL
739-
o Fix RENAME to work on variables other than OLD/NEW
740+
* PL/pgSQL
741+
o Fix RENAME to work on variables other than OLD/NEW
740742

741-
http://archives.postgresql.org/pgsql-hackers/2002-03/msg00591.php
742-
http://archives.postgresql.org/pgsql-hackers/2007-01/msg01615.php
743-
http://archives.postgresql.org/pgsql-hackers/2007-01/msg01587.php
743+
http://archives.postgresql.org/pgsql-hackers/2002-03/msg00591.php
744+
http://archives.postgresql.org/pgsql-hackers/2007-01/msg01615.php
745+
http://archives.postgresql.org/pgsql-hackers/2007-01/msg01587.php
744746

745-
o Allow function parameters to be passed by name,
746-
get_employee_salary(12345 AS emp_id, 2001 AS tax_year)
747-
o Allow handling of %TYPE arrays, e.g. tab.col%TYPE[]
748-
o Allow listing of record column names, and access to
749-
record columns via variables, e.g. columns := r.(*),
750-
tval2 := r.(colname)
747+
o Allow function parameters to be passed by name,
748+
get_employee_salary(12345 AS emp_id, 2001 AS tax_year)
749+
o Allow handling of %TYPE arrays, e.g. tab.col%TYPE[]
750+
o Allow listing of record column names, and access to
751+
record columns via variables, e.g. columns := r.(*),
752+
tval2 := r.(colname)
751753

752-
http://archives.postgresql.org/pgsql-patches/2005-07/msg00458.php
753-
http://archives.postgresql.org/pgsql-patches/2006-05/msg00302.php
754-
http://archives.postgresql.org/pgsql-patches/2006-06/msg00031.php
754+
http://archives.postgresql.org/pgsql-patches/2005-07/msg00458.php
755+
http://archives.postgresql.org/pgsql-patches/2006-05/msg00302.php
756+
http://archives.postgresql.org/pgsql-patches/2006-06/msg00031.php
755757

756-
o Add support for SCROLL cursors
757-
o Add support for WITH HOLD cursors
758-
o Allow row and record variables to be set to NULL constants,
759-
and allow NULL tests on such variables
758+
o Add support for SCROLL cursors
759+
o Add support for WITH HOLD cursors
760+
o Allow row and record variables to be set to NULL constants,
761+
and allow NULL tests on such variables
760762

761-
Because a row is not scalar, do not allow assignment
762-
from NULL-valued scalars.
763+
Because a row is not scalar, do not allow assignment
764+
from NULL-valued scalars.
763765

764-
http://archives.postgresql.org/pgsql-hackers/2006-10/msg00070.php
766+
http://archives.postgresql.org/pgsql-hackers/2006-10/msg00070.php
765767

766-
o Other
767-
o Add table function support to pltcl, plpythonu
768-
o Add support for polymorphic arguments and return types to
769-
languages other than PL/PgSQL
770-
o Add capability to create and call PROCEDURES
771-
o Add support for OUT and INOUT parameters to languages other
772-
than PL/PgSQL
773-
o Add PL/PythonU tracebacks
768+
* Other
769+
o Add table function support to pltcl, plpythonu
770+
o Add support for polymorphic arguments and return types to
771+
languages other than PL/PgSQL
772+
o Add capability to create and call PROCEDURES
773+
o Add support for OUT and INOUT parameters to languages other
774+
than PL/PgSQL
775+
o Add PL/PythonU tracebacks
774776

775-
http://archives.postgresql.org/pgsql-patches/2006-02/msg00288.php
777+
http://archives.postgresql.org/pgsql-patches/2006-02/msg00288.php
776778

777-
o Allow data to be passed in native language formats, rather
778-
than only text
779+
o Allow data to be passed in native language formats, rather
780+
than only text
779781

780-
http://archives.postgresql.org/pgsql-hackers/2007-05/msg00289.php
782+
http://archives.postgresql.org/pgsql-hackers/2007-05/msg00289.php
781783

782784

783785
Clients

‎doc/src/FAQ/TODO.html

Lines changed: 76 additions & 75 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
<bodybgcolor="#FFFFFF"text="#000000"link="#FF0000"vlink="#A00000"alink="#0000FF">
99
<h1><aname="section_1">PostgreSQL TODO List</a></h1>
1010
<p>Current maintainer: Bruce Momjian (<ahref="mailto:bruce@momjian.us">bruce@momjian.us</a>)<br/>
11-
Last updated: Wed Mar 511:07:13 EST 2008
11+
Last updated: Wed Mar 522:15:29 EST 2008
1212
</p>
1313
<p>The most recent version of this document can be viewed at<br/>
1414
<ahref="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.
@@ -623,74 +623,75 @@ <h1><a name="section_7">SQL Commands</a></h1>
623623
<li>Add SET PERFORMANCE_TIPS option to suggest INDEX, VACUUM, VACUUM
624624
ANALYZE, and CLUSTER
625625
</li></ul>
626-
</li><li>Referential Integrity
626+
</li></ul>
627+
<h1><aname="section_8">Referential Integrity</a></h1>
628+
629+
<ul>
630+
<li>Add MATCH PARTIAL referential integrity
631+
</li><li>Change foreign key constraint for array -&gt; element to mean element
632+
in array?
633+
</li><li>Fix problem when cascading referential triggers make changes on
634+
cascaded tables, seeing the tables in an intermediate state
635+
<p><ahref="http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php">http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php</a>
636+
<ahref="http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php">http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php</a>
637+
</p>
638+
</li><li>Allow DEFERRABLE and end-of-statement UNIQUE constraints?
639+
<p> This would allow UPDATE tab SET col = col + 1 to work if col has
640+
a unique index. Currently, uniqueness checks are done while the
641+
command is being executed, rather than at the end of the statement
642+
or transaction.
643+
<ahref="http://people.planetpostgresql.org/greg/index.php?/archives/2006/06/10.html">http://people.planetpostgresql.org/greg/index.php?/archives/2006/06/10.html</a>
644+
<ahref="http://archives.postgresql.org/pgsql-hackers/2006-09/msg01458.php">http://archives.postgresql.org/pgsql-hackers/2006-09/msg01458.php</a>
645+
</p>
646+
</li></ul>
647+
<h1><aname="section_9">Server-Side Languages</a></h1>
648+
649+
<ul>
650+
<li>PL/pgSQL
627651
<ul>
628-
<li>Add MATCH PARTIAL referential integrity
629-
</li><li>Change foreign key constraint for array -&gt; element to mean element
630-
in array?
631-
</li><li>Fix problem when cascading referential triggers make changes on
632-
cascaded tables, seeing the tables in an intermediate state
633-
<p><ahref="http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php">http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php</a>
634-
<ahref="http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php">http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php</a>
635-
</p>
636-
</li><li>Allow DEFERRABLE and end-of-statement UNIQUE constraints?
637-
<p> This would allow UPDATE tab SET col = col + 1 to work if col has
638-
a unique index. Currently, uniqueness checks are done while the
639-
command is being executed, rather than at the end of the statement
640-
or transaction.
641-
</p>
642-
<p><ahref="http://people.planetpostgresql.org/greg/index.php?/archives/2006/06/10.html">http://people.planetpostgresql.org/greg/index.php?/archives/2006/06/10.html</a>
643-
<ahref="http://archives.postgresql.org/pgsql-hackers/2006-09/msg01458.php">http://archives.postgresql.org/pgsql-hackers/2006-09/msg01458.php</a>
652+
<li>Fix RENAME to work on variables other than OLD/NEW
653+
<p><ahref="http://archives.postgresql.org/pgsql-hackers/2002-03/msg00591.php">http://archives.postgresql.org/pgsql-hackers/2002-03/msg00591.php</a>
654+
<ahref="http://archives.postgresql.org/pgsql-hackers/2007-01/msg01615.php">http://archives.postgresql.org/pgsql-hackers/2007-01/msg01615.php</a>
655+
<ahref="http://archives.postgresql.org/pgsql-hackers/2007-01/msg01587.php">http://archives.postgresql.org/pgsql-hackers/2007-01/msg01587.php</a>
656+
</p>
657+
</li><li>Allow function parameters to be passed by name,
658+
get_employee_salary(12345 AS emp_id, 2001 AS tax_year)
659+
</li><li>Allow handling of %TYPE arrays, e.g. tab.col%TYPE[<ahref="http://momjian.postgresql.org/cgi-bin/pgtodo?"></a>]
660+
</li><li>Allow listing of record column names, and access to
661+
record columns via variables, e.g. columns := r.(*),
662+
tval2 := r.(colname)
663+
<p><ahref="http://archives.postgresql.org/pgsql-patches/2005-07/msg00458.php">http://archives.postgresql.org/pgsql-patches/2005-07/msg00458.php</a>
664+
<ahref="http://archives.postgresql.org/pgsql-patches/2006-05/msg00302.php">http://archives.postgresql.org/pgsql-patches/2006-05/msg00302.php</a>
665+
<ahref="http://archives.postgresql.org/pgsql-patches/2006-06/msg00031.php">http://archives.postgresql.org/pgsql-patches/2006-06/msg00031.php</a>
666+
</p>
667+
</li><li>Add support for SCROLL cursors
668+
</li><li>Add support for WITH HOLD cursors
669+
</li><li>Allow row and record variables to be set to NULL constants,
670+
and allow NULL tests on such variables
671+
<p> Because a row is not scalar, do not allow assignment
672+
from NULL-valued scalars.
673+
</p>
674+
<p><ahref="http://archives.postgresql.org/pgsql-hackers/2006-10/msg00070.php">http://archives.postgresql.org/pgsql-hackers/2006-10/msg00070.php</a>
644675
</p>
645676
</li></ul>
646-
</li><li>Server-Side Languages
677+
</li><li>Other
647678
<ul>
648-
<li>PL/pgSQL
649-
<ul>
650-
<li>Fix RENAME to work on variables other than OLD/NEW
651-
<p><ahref="http://archives.postgresql.org/pgsql-hackers/2002-03/msg00591.php">http://archives.postgresql.org/pgsql-hackers/2002-03/msg00591.php</a>
652-
<ahref="http://archives.postgresql.org/pgsql-hackers/2007-01/msg01615.php">http://archives.postgresql.org/pgsql-hackers/2007-01/msg01615.php</a>
653-
<ahref="http://archives.postgresql.org/pgsql-hackers/2007-01/msg01587.php">http://archives.postgresql.org/pgsql-hackers/2007-01/msg01587.php</a>
654-
</p>
655-
</li><li>Allow function parameters to be passed by name,
656-
get_employee_salary(12345 AS emp_id, 2001 AS tax_year)
657-
</li><li>Allow handling of %TYPE arrays, e.g. tab.col%TYPE[<ahref="http://momjian.postgresql.org/cgi-bin/pgtodo?"></a>]
658-
</li><li>Allow listing of record column names, and access to
659-
record columns via variables, e.g. columns := r.(*),
660-
tval2 := r.(colname)
661-
<p><ahref="http://archives.postgresql.org/pgsql-patches/2005-07/msg00458.php">http://archives.postgresql.org/pgsql-patches/2005-07/msg00458.php</a>
662-
<ahref="http://archives.postgresql.org/pgsql-patches/2006-05/msg00302.php">http://archives.postgresql.org/pgsql-patches/2006-05/msg00302.php</a>
663-
<ahref="http://archives.postgresql.org/pgsql-patches/2006-06/msg00031.php">http://archives.postgresql.org/pgsql-patches/2006-06/msg00031.php</a>
664-
</p>
665-
</li><li>Add support for SCROLL cursors
666-
</li><li>Add support for WITH HOLD cursors
667-
</li><li>Allow row and record variables to be set to NULL constants,
668-
and allow NULL tests on such variables
669-
<p> Because a row is not scalar, do not allow assignment
670-
from NULL-valued scalars.
671-
</p>
672-
<p><ahref="http://archives.postgresql.org/pgsql-hackers/2006-10/msg00070.php">http://archives.postgresql.org/pgsql-hackers/2006-10/msg00070.php</a>
673-
</p>
674-
</li></ul>
675-
</li><li>Other
676-
<ul>
677-
<li>Add table function support to pltcl, plpythonu
678-
</li><li>Add support for polymorphic arguments and return types to
679-
languages other than PL/PgSQL
680-
</li><li>Add capability to create and call PROCEDURES
681-
</li><li>Add support for OUT and INOUT parameters to languages other
682-
than PL/PgSQL
683-
</li><li>Add PL/PythonU tracebacks
684-
<p><ahref="http://archives.postgresql.org/pgsql-patches/2006-02/msg00288.php">http://archives.postgresql.org/pgsql-patches/2006-02/msg00288.php</a>
685-
</p>
686-
</li><li>Allow data to be passed in native language formats, rather
687-
than only text
688-
<p><ahref="http://archives.postgresql.org/pgsql-hackers/2007-05/msg00289.php">http://archives.postgresql.org/pgsql-hackers/2007-05/msg00289.php</a>
679+
<li>Add table function support to pltcl, plpythonu
680+
</li><li>Add support for polymorphic arguments and return types to
681+
languages other than PL/PgSQL
682+
</li><li>Add capability to create and call PROCEDURES
683+
</li><li>Add support for OUT and INOUT parameters to languages other
684+
than PL/PgSQL
685+
</li><li>Add PL/PythonU tracebacks
686+
<p><ahref="http://archives.postgresql.org/pgsql-patches/2006-02/msg00288.php">http://archives.postgresql.org/pgsql-patches/2006-02/msg00288.php</a>
687+
</p>
688+
</li><li>Allow data to be passed in native language formats, rather
689+
than only text
690+
<p><ahref="http://archives.postgresql.org/pgsql-hackers/2007-05/msg00289.php">http://archives.postgresql.org/pgsql-hackers/2007-05/msg00289.php</a>
689691
</p>
690-
</li></ul>
691692
</li></ul>
692693
</li></ul>
693-
<h1><aname="section_8">Clients</a></h1>
694+
<h1><aname="section_10">Clients</a></h1>
694695

695696
<ul>
696697
<li>Have pg_ctl look at PGHOST in case it is a socket directory?
@@ -821,7 +822,7 @@ <h1><a name="section_8">Clients</a></h1>
821822
</p>
822823
</li></ul>
823824
</li></ul>
824-
<h1><aname="section_9">Triggers</a></h1>
825+
<h1><aname="section_11">Triggers</a></h1>
825826

826827
<ul>
827828
<li>Add deferred trigger queue file
@@ -859,7 +860,7 @@ <h1><a name="section_9">Triggers</a></h1>
859860
<p><ahref="http://archives.postgresql.org/pgsql-sql/2008-01/msg00050.php">http://archives.postgresql.org/pgsql-sql/2008-01/msg00050.php</a>
860861
</p>
861862
</li></ul>
862-
<h1><aname="section_10">Indexes</a></h1>
863+
<h1><aname="section_12">Indexes</a></h1>
863864

864865
<ul>
865866
<li>Add UNIQUE capability to non-btree indexes
@@ -931,7 +932,7 @@ <h1><a name="section_10">Indexes</a></h1>
931932
<p><ahref="http://archives.postgresql.org/pgsql-hackers/2007-03/msg01199.php">http://archives.postgresql.org/pgsql-hackers/2007-03/msg01199.php</a>
932933
</p>
933934
</li></ul>
934-
<h1><aname="section_11">Fsync</a></h1>
935+
<h1><aname="section_13">Fsync</a></h1>
935936

936937
<ul>
937938
<li>Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options
@@ -941,7 +942,7 @@ <h1><a name="section_11">Fsync</a></h1>
941942
</p>
942943
</li><li>Add program to test if fsync has a delay compared to non-fsync
943944
</li></ul>
944-
<h1><aname="section_12">Cache Usage</a></h1>
945+
<h1><aname="section_14">Cache Usage</a></h1>
945946

946947
<ul>
947948
<li>Speed up COUNT(*)
@@ -994,7 +995,7 @@ <h1><a name="section_12">Cache Usage</a></h1>
994995
<ahref="http://archives.postgresql.org/pgsql-hackers/2007-01/msg00752.php">http://archives.postgresql.org/pgsql-hackers/2007-01/msg00752.php</a>
995996
</p>
996997
</li></ul>
997-
<h1><aname="section_13">Vacuum</a></h1>
998+
<h1><aname="section_15">Vacuum</a></h1>
998999

9991000
<ul>
10001001
<li>Improve speed with indexes
@@ -1045,7 +1046,7 @@ <h1><a name="section_13">Vacuum</a></h1>
10451046
</p>
10461047
</li></ul>
10471048
</li></ul>
1048-
<h1><aname="section_14">Locking</a></h1>
1049+
<h1><aname="section_16">Locking</a></h1>
10491050

10501051
<ul>
10511052
<li>Fix priority ordering of read and write light-weight locks (Neil)
@@ -1071,7 +1072,7 @@ <h1><a name="section_14">Locking</a></h1>
10711072
<ahref="http://archives.postgresql.org/pgsql-committers/2008-01/msg00365.php">http://archives.postgresql.org/pgsql-committers/2008-01/msg00365.php</a>
10721073
</p>
10731074
</li></ul>
1074-
<h1><aname="section_15">Startup Time Improvements</a></h1>
1075+
<h1><aname="section_17">Startup Time Improvements</a></h1>
10751076

10761077
<ul>
10771078
<li>Experiment with multi-threaded backend for backend creation [<ahref="http://momjian.postgresql.org/cgi-bin/pgtodo?thread">thread</a>]
@@ -1082,7 +1083,7 @@ <h1><a name="section_15">Startup Time Improvements</a></h1>
10821083
a single session using multiple threads to execute a statement faster.
10831084
</p>
10841085
</li></ul>
1085-
<h1><aname="section_16">Write-Ahead Log</a></h1>
1086+
<h1><aname="section_18">Write-Ahead Log</a></h1>
10861087

10871088
<ul>
10881089
<li>Eliminate need to write full pages to WAL before page modification [<ahref="http://momjian.postgresql.org/cgi-bin/pgtodo?wal">wal</a>]
@@ -1143,7 +1144,7 @@ <h1><a name="section_16">Write-Ahead Log</a></h1>
11431144
<ahref="http://archives.postgresql.org/pgsql-hackers/2008-02/msg01279.php">http://archives.postgresql.org/pgsql-hackers/2008-02/msg01279.php</a>
11441145
</p>
11451146
</li></ul>
1146-
<h1><aname="section_17">Optimizer / Executor</a></h1>
1147+
<h1><aname="section_19">Optimizer / Executor</a></h1>
11471148

11481149
<ul>
11491150
<li>Improve selectivity functions for geometric operators
@@ -1166,7 +1167,7 @@ <h1><a name="section_17">Optimizer / Executor</a></h1>
11661167
<p><ahref="http://archives.postgresql.org/pgsql-hackers/2007-01/msg00096.php">http://archives.postgresql.org/pgsql-hackers/2007-01/msg00096.php</a>
11671168
</p>
11681169
</li></ul>
1169-
<h1><aname="section_18">Miscellaneous Performance</a></h1>
1170+
<h1><aname="section_20">Miscellaneous Performance</a></h1>
11701171

11711172
<ul>
11721173
<li>Do async I/O for faster random read-ahead of data
@@ -1219,7 +1220,7 @@ <h1><a name="section_18">Miscellaneous Performance</a></h1>
12191220
concurrent reads from multiple devices in a partitioned table.
12201221
</p>
12211222
</li></ul>
1222-
<h1><aname="section_19">Source Code</a></h1>
1223+
<h1><aname="section_21">Source Code</a></h1>
12231224

12241225
<ul>
12251226
<li>Add use of 'const' for variables in source tree
@@ -1286,7 +1287,7 @@ <h1><a name="section_19">Source Code</a></h1>
12861287
of result sets using new statement protocol
12871288
</li></ul>
12881289
</li></ul>
1289-
<h1><aname="section_20">Exotic Features</a></h1>
1290+
<h1><aname="section_22">Exotic Features</a></h1>
12901291

12911292
<ul>
12921293
<li>Add pre-parsing phase that converts non-ISO syntax to supported
@@ -1313,7 +1314,7 @@ <h1><a name="section_20">Exotic Features</a></h1>
13131314
<p><ahref="http://archives.postgresql.org/pgsql-hackers/2008-01/msg00893.php">http://archives.postgresql.org/pgsql-hackers/2008-01/msg00893.php</a>
13141315
</p>
13151316
</li></ul>
1316-
<h1><aname="section_21">Features We Do<u>Not</u> Want</a></h1>
1317+
<h1><aname="section_23">Features We Do<u>Not</u> Want</a></h1>
13171318

13181319
<ul>
13191320
<li>All backends running as threads in a single process (not wanted)

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp