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

Commitcad7f83

Browse files
committed
Update based on user comments:
< in PL/PgSQL is to use EXECUTE.> in PL/PgSQL is to use EXECUTE. One complexity is that a function> might itself drop and recreate dependent tables, causing it to> invalidate its own query plan.
1 parentbdfa8e5 commitcad7f83

File tree

2 files changed

+8
-4
lines changed

2 files changed

+8
-4
lines changed

‎doc/TODO

Lines changed: 4 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
PostgreSQL TODO List
33
====================
44
Current maintainer:Bruce Momjian (pgman@candle.pha.pa.us)
5-
Last updated:Fri Aug 26 15:10:29 EDT 2005
5+
Last updated:Fri Aug 26 15:32:39 EDT 2005
66

77
The most recent version of this document can be viewed at
88
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -621,7 +621,9 @@ Dependency Checking
621621

622622
This is particularly important for references to temporary tables
623623
in PL/PgSQL because PL/PgSQL caches query plans. The only workaround
624-
in PL/PgSQL is to use EXECUTE.
624+
in PL/PgSQL is to use EXECUTE. One complexity is that a function
625+
might itself drop and recreate dependent tables, causing it to
626+
invalidate its own query plan.
625627

626628

627629
Exotic Features

‎doc/src/FAQ/TODO.html

Lines changed: 4 additions & 2 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:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</a>)<br/>
11-
Last updated: Fri Aug 26 15:10:29 EDT 2005
11+
Last updated: Fri Aug 26 15:32:39 EDT 2005
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>.
@@ -563,7 +563,9 @@ <h1><a name="section_11">Dependency Checking</a></h1>
563563
</li><li>Track dependencies in function bodies and recompile/invalidate
564564
<p> This is particularly important for references to temporary tables
565565
in PL/PgSQL because PL/PgSQL caches query plans. The only workaround
566-
in PL/PgSQL is to use EXECUTE.
566+
in PL/PgSQL is to use EXECUTE. One complexity is that a function
567+
might itself drop and recreate dependent tables, causing it to
568+
invalidate its own query plan.
567569
</p>
568570
</li></ul>
569571
<h1><aname="section_12">Exotic Features</a></h1>

0 commit comments

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