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

Commit5bb9c25

Browse files
committed
Done:
< Last updated:Tue Aug 29 12:21:52 EDT 2006> Last updated:Wed Aug 30 20:34:28 EDT 2006< o Allow COPY (SELECT ...) TO 'filename'<< COPY should also be able to output views using COPY (SELECT< * FROM view) TO 'filename' internally.<http://archives.postgresql.org/pgsql-patches/2005-09/msg00148.php> o -Allow COPY (SELECT ...) TO 'filename'
1 parent85188ab commit5bb9c25

File tree

2 files changed

+34
-41
lines changed

2 files changed

+34
-41
lines changed

‎doc/TODO‎

Lines changed: 3 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -1,8 +1,8 @@
1-
1+
c
22
PostgreSQL TODO List
33
====================
44
Current maintainer:Bruce Momjian (bruce@momjian.us)
5-
Last updated:Tue Aug29 12:21:52 EDT 2006
5+
Last updated:Wed Aug30 20:34:28 EDT 2006
66

77
The most recent version of this document can be viewed at
88
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -612,11 +612,7 @@ SQL Commands
612612
the table at the same time, which is something that is
613613
currently allowed.
614614

615-
o Allow COPY (SELECT ...) TO 'filename'
616-
617-
COPY should also be able to output views using COPY (SELECT
618-
* FROM view) TO 'filename' internally.
619-
http://archives.postgresql.org/pgsql-patches/2005-09/msg00148.php
615+
o -Allow COPY (SELECT ...) TO 'filename'
620616

621617

622618
* GRANT/REVOKE

‎doc/src/FAQ/TODO.html‎

Lines changed: 31 additions & 34 deletions
Original file line numberDiff line numberDiff line change
@@ -2,14 +2,16 @@
22
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
33
<html>
44
<head>
5-
<title>PostgreSQL TODO List</title>
5+
<title>c</title>
66
<metaname="generator"content="HTML::TextToHTML v2.25"/>
77
</head>
88
<bodybgcolor="#FFFFFF"text="#000000"link="#FF0000"vlink="#A00000"alink="#0000FF">
9-
<h1><aname="section_1">PostgreSQL TODO List</a></h1>
10-
<p>Current maintainer: Bruce Momjian (<ahref="mailto:bruce@momjian.us">bruce@momjian.us</a>)<br/>
11-
Last updated: Tue Aug 29 12:21:52 EDT 2006
12-
</p>
9+
<p>c<br/>
10+
PostgreSQL TODO List
11+
</p><hr/>
12+
Current maintainer: Bruce Momjian (<ahref="mailto:bruce@momjian.us">bruce@momjian.us</a>)<br/>
13+
Last updated: Wed Aug 30 20:34:28 EDT 2006
14+
1315
<p>The most recent version of this document can be viewed at<br/>
1416
<ahref="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.
1517
</p>
@@ -22,7 +24,7 @@ <h1><a name="section_1">PostgreSQL TODO List</a></h1>
2224
you would like to work on an item, please read the Developer's FAQ<br/>
2325
first.
2426
</p>
25-
<h1><aname="section_2">Administration</a></h1>
27+
<h1><aname="section_1">Administration</a></h1>
2628

2729
<ul>
2830
<li>-<em>Make postmater and postgres options distinct so the postmaster -o</em>
@@ -150,7 +152,7 @@ <h1><a name="section_2">Administration</a></h1>
150152
</li><li>Allow the PITR process to be debugged and data examined
151153
</li></ul>
152154
</li></ul>
153-
<h1><aname="section_3">Monitoring</a></h1>
155+
<h1><aname="section_2">Monitoring</a></h1>
154156

155157
<ul>
156158
<li>Allow server log information to be output as INSERT statements
@@ -161,7 +163,7 @@ <h1><a name="section_3">Monitoring</a></h1>
161163
</li><li>-<em>Allow server logs to be remotely read and removed using SQL commands</em>
162164
</li><li>-<em>Allow protocol-level BIND parameter values to be logged, if text mode</em>
163165
</li></ul>
164-
<h1><aname="section_4">Data Types</a></h1>
166+
<h1><aname="section_3">Data Types</a></h1>
165167

166168
<ul>
167169
<li>Improve the MONEY data type
@@ -296,7 +298,7 @@ <h1><a name="section_4">Data Types</a></h1>
296298
</li></ul>
297299
</li></ul>
298300
</li></ul>
299-
<h1><aname="section_5">Functions</a></h1>
301+
<h1><aname="section_4">Functions</a></h1>
300302

301303
<ul>
302304
<li>Allow INET subnet tests using non-constants to be indexed
@@ -339,7 +341,7 @@ <h1><a name="section_5">Functions</a></h1>
339341
</li><li>Add SPI_gettypmod() to return the typemod for a TupleDesc
340342
</li><li>Allow inlining of set-returning functions
341343
</li></ul>
342-
<h1><aname="section_6">Multi-Language Support</a></h1>
344+
<h1><aname="section_5">Multi-Language Support</a></h1>
343345

344346
<ul>
345347
<li>Add NCHAR (as distinguished from ordinary varchar),
@@ -370,7 +372,7 @@ <h1><a name="section_6">Multi-Language Support</a></h1>
370372
<ahref="http://archives.postgresql.org/pgsql-patches/2005-11/msg00173.php">http://archives.postgresql.org/pgsql-patches/2005-11/msg00173.php</a>
371373
</p>
372374
</li></ul>
373-
<h1><aname="section_7">Views / Rules</a></h1>
375+
<h1><aname="section_6">Views / Rules</a></h1>
374376

375377
<ul>
376378
<li>Automatically create rules on views so they are updateable, per SQL99
@@ -386,7 +388,7 @@ <h1><a name="section_7">Views / Rules</a></h1>
386388
are added after the view is created.
387389
</p>
388390
</li></ul>
389-
<h1><aname="section_8">SQL Commands</a></h1>
391+
<h1><aname="section_7">SQL Commands</a></h1>
390392

391393
<ul>
392394
<li>-<em>Change LIMIT/OFFSET and FETCH/MOVE to use int8</em>
@@ -557,12 +559,7 @@ <h1><a name="section_8">SQL Commands</a></h1>
557559
the table at the same time, which is something that is
558560
currently allowed.
559561
</p>
560-
</li><li>Allow COPY (SELECT ...) TO 'filename'
561-
<p> COPY should also be able to output views using COPY (SELECT
562-
</p><ul>
563-
<li>FROM view) TO 'filename' internally.
564-
<ahref="http://archives.postgresql.org/pgsql-patches/2005-09/msg00148.php">http://archives.postgresql.org/pgsql-patches/2005-09/msg00148.php</a>
565-
</li></ul>
562+
</li><li>-<em>Allow COPY (SELECT ...) TO 'filename'</em>
566563
</li></ul>
567564
</li><li>GRANT/REVOKE
568565
<ul>
@@ -685,7 +682,7 @@ <h1><a name="section_8">SQL Commands</a></h1>
685682
</li></ul>
686683
</li></ul>
687684
</li></ul>
688-
<h1><aname="section_9">Clients</a></h1>
685+
<h1><aname="section_8">Clients</a></h1>
689686

690687
<ul>
691688
<li>-<em>Have initdb set the input DateStyle (MDY or DMY) based on locale</em>
@@ -794,7 +791,7 @@ <h1><a name="section_9">Clients</a></h1>
794791
</p>
795792
</li></ul>
796793
</li></ul>
797-
<h1><aname="section_10">Triggers</a></h1>
794+
<h1><aname="section_9">Triggers</a></h1>
798795
<ul>
799796
<li>Add deferred trigger queue file
800797
<p> Right now all deferred trigger information is stored in backend
@@ -822,7 +819,7 @@ <h1><a name="section_10">Triggers</a></h1>
822819
to fire triggers.
823820
</p>
824821
</li></ul>
825-
<h1><aname="section_11">Dependency Checking</a></h1>
822+
<h1><aname="section_10">Dependency Checking</a></h1>
826823

827824
<ul>
828825
<li>Flush cached query plans when the dependent objects change,
@@ -839,7 +836,7 @@ <h1><a name="section_11">Dependency Checking</a></h1>
839836
invalidate its own query plan.
840837
</p>
841838
</li></ul>
842-
<h1><aname="section_12">Exotic Features</a></h1>
839+
<h1><aname="section_11">Exotic Features</a></h1>
843840

844841
<ul>
845842
<li>Add pre-parsing phase that converts non-ISO syntax to supported
@@ -866,7 +863,7 @@ <h1><a name="section_12">Exotic Features</a></h1>
866863
<p><ahref="http://archives.postgresql.org/pgsql-hackers/2004-04/msg00818.php">http://archives.postgresql.org/pgsql-hackers/2004-04/msg00818.php</a>
867864
</p>
868865
</li></ul>
869-
<h1><aname="section_13">Indexes</a></h1>
866+
<h1><aname="section_12">Indexes</a></h1>
870867

871868
<ul>
872869
<li>Allow inherited tables to inherit index, UNIQUE constraint, and primary
@@ -933,7 +930,7 @@ <h1><a name="section_13">Indexes</a></h1>
933930
</li><li>Allow multi-column hash indexes
934931
</li></ul>
935932
</li></ul>
936-
<h1><aname="section_14">Fsync</a></h1>
933+
<h1><aname="section_13">Fsync</a></h1>
937934

938935
<ul>
939936
<li>Improve commit_delay handling to reduce fsync()
@@ -945,7 +942,7 @@ <h1><a name="section_14">Fsync</a></h1>
945942
</li><li>%Add an option to sync() before fsync()'ing checkpoint files
946943
</li><li>Add program to test if fsync has a delay compared to non-fsync
947944
</li></ul>
948-
<h1><aname="section_15">Cache Usage</a></h1>
945+
<h1><aname="section_14">Cache Usage</a></h1>
949946

950947
<ul>
951948
<li>Allow free-behind capability for large sequential scans, perhaps using
@@ -999,7 +996,7 @@ <h1><a name="section_15">Cache Usage</a></h1>
999996
<p><ahref="http://archives.postgresql.org/pgsql-hackers/2005-10/msg01419.php">http://archives.postgresql.org/pgsql-hackers/2005-10/msg01419.php</a>
1000997
</p>
1001998
</li></ul>
1002-
<h1><aname="section_16">Vacuum</a></h1>
999+
<h1><aname="section_15">Vacuum</a></h1>
10031000

10041001
<ul>
10051002
<li>Improve speed with indexes
@@ -1057,12 +1054,12 @@ <h1><a name="section_16">Vacuum</a></h1>
10571054
</li><li>Turn on by default
10581055
</li></ul>
10591056
</li></ul>
1060-
<h1><aname="section_17">Locking</a></h1>
1057+
<h1><aname="section_16">Locking</a></h1>
10611058

10621059
<ul>
10631060
<li>Fix priority ordering of read and write light-weight locks (Neil)
10641061
</li></ul>
1065-
<h1><aname="section_18">Startup Time Improvements</a></h1>
1062+
<h1><aname="section_17">Startup Time Improvements</a></h1>
10661063

10671064
<ul>
10681065
<li>Experiment with multi-threaded backend for backend creation [<ahref="http://momjian.postgresql.org/cgi-bin/pgtodo?thread">thread</a>]
@@ -1085,7 +1082,7 @@ <h1><a name="section_18">Startup Time Improvements</a></h1>
10851082
existing backends is one of the difficulties with a backend approach.
10861083
</p>
10871084
</li></ul>
1088-
<h1><aname="section_19">Write-Ahead Log</a></h1>
1085+
<h1><aname="section_18">Write-Ahead Log</a></h1>
10891086

10901087
<ul>
10911088
<li>Eliminate need to write full pages to WAL before page modification [<ahref="http://momjian.postgresql.org/cgi-bin/pgtodo?wal">wal</a>]
@@ -1149,7 +1146,7 @@ <h1><a name="section_19">Write-Ahead Log</a></h1>
11491146
of indexes on TOAST tables.
11501147
</p>
11511148
</li></ul>
1152-
<h1><aname="section_20">Optimizer / Executor</a></h1>
1149+
<h1><aname="section_19">Optimizer / Executor</a></h1>
11531150

11541151
<ul>
11551152
<li>Improve selectivity functions for geometric operators
@@ -1174,7 +1171,7 @@ <h1><a name="section_20">Optimizer / Executor</a></h1>
11741171
<p> This might replace GEQO,<ahref="http://sixdemonbag.org/Djinni">http://sixdemonbag.org/Djinni</a>.
11751172
</p>
11761173
</li></ul>
1177-
<h1><aname="section_21">Miscellaneous Performance</a></h1>
1174+
<h1><aname="section_20">Miscellaneous Performance</a></h1>
11781175

11791176
<ul>
11801177
<li>Do async I/O for faster random read-ahead of data
@@ -1217,7 +1214,7 @@ <h1><a name="section_21">Miscellaneous Performance</a></h1>
12171214
</p>
12181215
</li><li>Research storing disk pages with no alignment/padding
12191216
</li></ul>
1220-
<h1><aname="section_22">Source Code</a></h1>
1217+
<h1><aname="section_21">Source Code</a></h1>
12211218

12221219
<ul>
12231220
<li>Add use of 'const' for variables in source tree
@@ -1299,7 +1296,7 @@ <h1><a name="section_22">Source Code</a></h1>
12991296
of result sets using new statement protocol
13001297
</li></ul>
13011298
</li></ul>
1302-
<h1><aname="section_23">Features We Do _Not_ Want</a></h1>
1299+
<h1><aname="section_22">Features We Do _Not_ Want</a></h1>
13031300

13041301
<ul>
13051302
<li>All backends running as threads in a single process (not wanted)
@@ -1320,7 +1317,7 @@ <h1><a name="section_23">Features We Do _Not_ Want</a></h1>
13201317
</li></ul>
13211318
<hr/>
13221319

1323-
<h2><aname="section_23_1">Developers who have claimed items are:</a></h2>
1320+
<h2><aname="section_22_1">Developers who have claimed items are:</a></h2>
13241321
<ul>
13251322
<li>Alvaro is Alvaro Herrera &lt;<ahref="mailto:alvherre@dcc.uchile.cl">alvherre@dcc.uchile.cl</a>&gt;
13261323
</li><li>Andrew is Andrew Dunstan &lt;<ahref="mailto:andrew@dunslane.net">andrew@dunslane.net</a>&gt;

0 commit comments

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