|
8 | 8 | <bodybgcolor="#FFFFFF"text="#000000"link="#FF0000"vlink="#A00000"alink="#0000FF">
|
9 | 9 | <h1><aname="section_1">PostgreSQL TODO List</a></h1>
|
10 | 10 | <p>Current maintainer: Bruce Momjian (<ahref="mailto:bruce@momjian.us">bruce@momjian.us</a>)<br/>
|
11 |
| -Last updated: Tue Apr 1510:24:22 EDT 2008 |
| 11 | +Last updated: Tue Apr 1511:06:48 EDT 2008 |
12 | 12 | </p>
|
13 | 13 | <p>The most recent version of this document can be viewed at<br/>
|
14 | 14 | <ahref="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.
|
@@ -522,19 +522,6 @@ <h1><a name="section_7">SQL Commands</a></h1>
|
522 | 522 | </p>
|
523 | 523 | </li><li>Improve logging of prepared transactions recovered during startup
|
524 | 524 | <p><ahref="http://archives.postgresql.org/pgsql-hackers/2006-11/msg00092.php">http://archives.postgresql.org/pgsql-hackers/2006-11/msg00092.php</a>
|
525 |
| -</p> |
526 |
| -</li><li>Allow LISTEN/NOTIFY to store info in memory rather than tables? |
527 |
| -<p> Currently LISTEN/NOTIFY information is stored in pg_listener. Storing |
528 |
| - such information in memory would improve performance. |
529 |
| -</p> |
530 |
| -</li><li>Add optional textual message to NOTIFY |
531 |
| -<p> This would allow an informational message to be added to the notify |
532 |
| - message, perhaps indicating the row modified or other custom |
533 |
| - information. |
534 |
| -</p> |
535 |
| -</li><li>Allow multiple identical NOTIFY events to always be communicated to the |
536 |
| - client, rather than sent as a single notification to the listener |
537 |
| -<p><ahref="http://archives.postgresql.org/pgsql-general/2008-01/msg00057.php">http://archives.postgresql.org/pgsql-general/2008-01/msg00057.php</a> |
538 | 525 | </p>
|
539 | 526 | </li><li>Add a GUC variable to warn about non-standard SQL usage in queries
|
540 | 527 | </li><li>Add SQL-standard MERGE command, typically used to merge two tables
|
@@ -758,6 +745,23 @@ <h1><a name="section_7">SQL Commands</a></h1>
|
758 | 745 | <li>Add SET PERFORMANCE_TIPS option to suggest INDEX, VACUUM, VACUUM
|
759 | 746 | ANALYZE, and CLUSTER
|
760 | 747 | </li></ul>
|
| 748 | +</li><li>LISTEN/NOTIFY |
| 749 | +<ul> |
| 750 | +<li>Allow LISTEN/NOTIFY to store info in memory rather than tables? |
| 751 | +<p> Currently LISTEN/NOTIFY information is stored in pg_listener. |
| 752 | + Storing such information in memory would improve performance. |
| 753 | +</p> |
| 754 | +</li><li>Add optional textual message to NOTIFY |
| 755 | +<p> This would allow an informational message to be added to the notify |
| 756 | + message, perhaps indicating the row modified or other custom |
| 757 | + information. |
| 758 | +</p> |
| 759 | +</li><li>Allow multiple identical NOTIFY events to always be communicated |
| 760 | + to the client, rather than sent as a single notification to the |
| 761 | + listener |
| 762 | +<p><ahref="http://archives.postgresql.org/pgsql-general/2008-01/msg00057.php">http://archives.postgresql.org/pgsql-general/2008-01/msg00057.php</a> |
| 763 | +</p> |
| 764 | +</li></ul> |
761 | 765 | </li></ul>
|
762 | 766 | <h1><aname="section_8">Referential Integrity</a></h1>
|
763 | 767 |
|
|