diff options
| author | Bruce Momjian <bruce@momjian.us> | 2008-01-14 22:14:30 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2008-01-14 22:14:30 +0000 |
| commit | 1272ac82b67ad1b92f4a807576c65d8661fbb6ce (patch) | |
| tree | fa07155f02382751382974b3a56ea152a2fdc7d4 | |
| parent | be8451e548ddb2a5c88566ae9c974449e7ab98c5 (diff) | |
| download | postgresql-1272ac82b67ad1b92f4a807576c65d8661fbb6ce.tar.gz postgresql-1272ac82b67ad1b92f4a807576c65d8661fbb6ce.zip | |
Add:
>
> * Add the ability to automatically create materialized views
>
> Right now materialized views require the user to create triggers on the
> main table to keep the summary table current. SQL syntax should be able
> to manager the triggers and summary table automatically. A more
> sophisticated implementation would automatically retrieve from the
> summary table when the main table is referenced, if possible.
>
| -rw-r--r-- | doc/TODO | 11 | ||||
| -rw-r--r-- | doc/src/FAQ/TODO.html | 9 |
2 files changed, 18 insertions, 2 deletions
@@ -1,7 +1,7 @@ PostgreSQL TODO List ==================== Current maintainer: Bruce Momjian (bruce@momjian.us) -Last updated: Fri Jan 11 11:49:17 EST 2008 +Last updated: Mon Jan 14 17:13:36 EST 2008 The most recent version of this document can be viewed at http://www.postgresql.org/docs/faqs.TODO.html. @@ -432,6 +432,15 @@ Views / Rules http://archives.postgresql.org/pgsql-hackers/2007-09/msg00577.php +* Add the ability to automatically create materialized views + + Right now materialized views require the user to create triggers on the + main table to keep the summary table current. SQL syntax should be able + to manager the triggers and summary table automatically. A more + sophisticated implementation would automatically retrieve from the + summary table when the main table is referenced, if possible. + + SQL Commands ============ diff --git a/doc/src/FAQ/TODO.html b/doc/src/FAQ/TODO.html index f216d0e5a13..420d27f9a60 100644 --- a/doc/src/FAQ/TODO.html +++ b/doc/src/FAQ/TODO.html @@ -8,7 +8,7 @@ <body bgcolor="#FFFFFF" text="#000000" link="#FF0000" vlink="#A00000" alink="#0000FF"> <h1><a name="section_1">PostgreSQL TODO List</a></h1> <p>Current maintainer: Bruce Momjian (<a href="mailto:bruce@momjian.us">bruce@momjian.us</a>)<br/> -Last updated: Fri Jan 11 11:49:17 EST 2008 +Last updated: Mon Jan 14 17:13:36 EST 2008 </p> <p>The most recent version of this document can be viewed at<br/> <a href="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>. @@ -386,6 +386,13 @@ first. There is also a developer's wiki at<br/> rules, such as for partitioning setups <p> <a href="http://archives.postgresql.org/pgsql-hackers/2007-09/msg00577.php">http://archives.postgresql.org/pgsql-hackers/2007-09/msg00577.php</a> </p> + </li><li>Add the ability to automatically create materialized views +<p> Right now materialized views require the user to create triggers on the + main table to keep the summary table current. SQL syntax should be able + to manager the triggers and summary table automatically. A more + sophisticated implementation would automatically retrieve from the + summary table when the main table is referenced, if possible. +</p> </li></ul> <h1><a name="section_7">SQL Commands</a></h1> |