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

Commit1272ac8

Browse files
committed
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.>
1 parentbe8451e commit1272ac8

File tree

2 files changed

+18
-2
lines changed

2 files changed

+18
-2
lines changed

‎doc/TODO

Lines changed: 10 additions & 1 deletion
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:Fri Jan11 11:49:17 EST 2008
4+
Last updated:Mon Jan14 17:13:36 EST 2008
55

66
The most recent version of this document can be viewed at
77
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -432,6 +432,15 @@ Views / Rules
432432

433433
http://archives.postgresql.org/pgsql-hackers/2007-09/msg00577.php
434434

435+
* Add the ability to automatically create materialized views
436+
437+
Right now materialized views require the user to create triggers on the
438+
main table to keep the summary table current. SQL syntax should be able
439+
to manager the triggers and summary table automatically. A more
440+
sophisticated implementation would automatically retrieve from the
441+
summary table when the main table is referenced, if possible.
442+
443+
435444

436445
SQL Commands
437446
============

‎doc/src/FAQ/TODO.html

Lines changed: 8 additions & 1 deletion
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:Fri Jan11 11:49:17 EST 2008
11+
Last updated:Mon Jan14 17:13:36 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>.
@@ -385,6 +385,13 @@ <h1><a name="section_6">Views / Rules</a></h1>
385385
</li><li>Make it possible to use RETURNING together with conditional DO INSTEAD
386386
rules, such as for partitioning setups
387387
<p><ahref="http://archives.postgresql.org/pgsql-hackers/2007-09/msg00577.php">http://archives.postgresql.org/pgsql-hackers/2007-09/msg00577.php</a>
388+
</p>
389+
</li><li>Add the ability to automatically create materialized views
390+
<p> Right now materialized views require the user to create triggers on the
391+
main table to keep the summary table current. SQL syntax should be able
392+
to manager the triggers and summary table automatically. A more
393+
sophisticated implementation would automatically retrieve from the
394+
summary table when the main table is referenced, if possible.
388395
</p>
389396
</li></ul>
390397
<h1><aname="section_7">SQL Commands</a></h1>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp