Skip to content

Commit 5bb9c25

Browse files
bmomjianbmomjian
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 parent 85188ab commit 5bb9c25

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 Aug 29 12:21:52 EDT 2006
5+
Last updated: Wed Aug 30 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
<meta name="generator" content="HTML::TextToHTML v2.25"/>
77
</head>
88
<body bgcolor="#FFFFFF" text="#000000" link="#FF0000" vlink="#A00000" alink="#0000FF">
9-
<h1><a name="section_1">PostgreSQL TODO List</a></h1>
10-
<p>Current maintainer: Bruce Momjian (<a href="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 (<a href="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
<a href="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><a name="section_2">Administration</a></h1>
27+
<h1><a name="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><a name="section_3">Monitoring</a></h1>
155+
<h1><a name="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><a name="section_4">Data Types</a></h1>
166+
<h1><a name="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><a name="section_5">Functions</a></h1>
301+
<h1><a name="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><a name="section_6">Multi-Language Support</a></h1>
344+
<h1><a name="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
<a href="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><a name="section_7">Views / Rules</a></h1>
375+
<h1><a name="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><a name="section_8">SQL Commands</a></h1>
391+
<h1><a name="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-
<a href="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><a name="section_9">Clients</a></h1>
685+
<h1><a name="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><a name="section_10">Triggers</a></h1>
794+
<h1><a name="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><a name="section_11">Dependency Checking</a></h1>
822+
<h1><a name="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><a name="section_12">Exotic Features</a></h1>
839+
<h1><a name="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> <a href="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><a name="section_13">Indexes</a></h1>
866+
<h1><a name="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><a name="section_14">Fsync</a></h1>
933+
<h1><a name="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><a name="section_15">Cache Usage</a></h1>
945+
<h1><a name="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> <a href="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><a name="section_16">Vacuum</a></h1>
999+
<h1><a name="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><a name="section_17">Locking</a></h1>
1057+
<h1><a name="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><a name="section_18">Startup Time Improvements</a></h1>
1062+
<h1><a name="section_17">Startup Time Improvements</a></h1>
10661063

10671064
<ul>
10681065
<li>Experiment with multi-threaded backend for backend creation [<a href="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><a name="section_19">Write-Ahead Log</a></h1>
1085+
<h1><a name="section_18">Write-Ahead Log</a></h1>
10891086

10901087
<ul>
10911088
<li>Eliminate need to write full pages to WAL before page modification [<a href="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><a name="section_20">Optimizer / Executor</a></h1>
1149+
<h1><a name="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, <a href="http://sixdemonbag.org/Djinni">http://sixdemonbag.org/Djinni</a>.
11751172
</p>
11761173
</li></ul>
1177-
<h1><a name="section_21">Miscellaneous Performance</a></h1>
1174+
<h1><a name="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><a name="section_22">Source Code</a></h1>
1217+
<h1><a name="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><a name="section_23">Features We Do _Not_ Want</a></h1>
1299+
<h1><a name="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><a name="section_23_1">Developers who have claimed items are:</a></h2>
1320+
<h2><a name="section_22_1">Developers who have claimed items are:</a></h2>
13241321
<ul>
13251322
<li>Alvaro is Alvaro Herrera &lt;<a href="mailto:alvherre@dcc.uchile.cl">alvherre@dcc.uchile.cl</a>&gt;
13261323
</li><li>Andrew is Andrew Dunstan &lt;<a href="mailto:andrew@dunslane.net">andrew@dunslane.net</a>&gt;

0 commit comments

Comments
 (0)