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

Commitef6d5b4

Browse files
committed
Update:
> o Allow COPY on a newly-created table to skip WAL logging450a452,456> On crash recovery, the table involved in the COPY would> have its heap and index files truncated. One issue is> that no other backend should be able to add to the table> at the same time, which is something that is currently> allowed.
1 parentf8ec875 commitef6d5b4

File tree

2 files changed

+15
-4
lines changed

2 files changed

+15
-4
lines changed

‎doc/TODO

Lines changed: 7 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 Sep 2 17:01:18 EDT 2005
5+
Last updated:Fri Sep 2 17:10:58 EDT 2005
66

77
The most recent version of this document can be viewed at
88
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -389,7 +389,6 @@ SQL Commands
389389
copy of db?
390390

391391
o Add ON COMMIT capability to CREATE TABLE AS ... SELECT
392-
o Allow COPY into an new table to skip WAL logging
393392

394393

395394
* UPDATE
@@ -448,7 +447,13 @@ SQL Commands
448447
processed, with ROLLBACK on COPY failure.
449448

450449
o %Have COPY return the number of rows loaded/unloaded?
450+
o Allow COPY on a newly-created table to skip WAL logging
451451

452+
On crash recovery, the table involved in the COPY would
453+
have its heap and index files truncated. One issue is
454+
that no other backend should be able to add to the table
455+
at the same time, which is something that is currently
456+
allowed.
452457

453458
* GRANT/REVOKE
454459

‎doc/src/FAQ/TODO.html

Lines changed: 8 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 Sep 2 17:01:18 EDT 2005
11+
Last updated: Fri Sep 2 17:10:58 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>.
@@ -355,7 +355,6 @@ <h1><a name="section_8">SQL Commands</a></h1>
355355
</li><li>Use more reliable method for CREATE DATABASE to get a consistent
356356
copy of db?
357357
</li><li>Add ON COMMIT capability to CREATE TABLE AS ... SELECT
358-
</li><li>Allow COPY into an new table to skip WAL logging
359358
</li></ul>
360359
</li><li>UPDATE
361360
<ul>
@@ -407,6 +406,13 @@ <h1><a name="section_8">SQL Commands</a></h1>
407406
processed, with ROLLBACK on COPY failure.
408407
</p>
409408
</li><li>%Have COPY return the number of rows loaded/unloaded?
409+
</li><li>Allow COPY on a newly-created table to skip WAL logging
410+
<p> On crash recovery, the table involved in the COPY would
411+
have its heap and index files truncated. One issue is
412+
that no other backend should be able to add to the table
413+
at the same time, which is something that is currently
414+
allowed.
415+
</p>
410416
</li></ul>
411417
</li><li>GRANT/REVOKE
412418
<ul>

0 commit comments

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