2
2
TODO list for PostgreSQL
3
3
========================
4
4
Current maintainer:Bruce Momjian (pgman@candle.pha.pa.us)
5
- Last updated:Sun Apr17 23:17 :13 EDT 2005
5
+ Last updated:Mon Apr18 08:51 :13 EDT 2005
6
6
7
7
The most recent version of this document can be viewed at the PostgreSQL web
8
8
site, http://www.PostgreSQL.org.
@@ -113,6 +113,10 @@ Administration
113
113
114
114
* Force archiving of partially-full WAL files when pg_stop_backup() is
115
115
called or the server is stopped
116
+
117
+ Doing this will allow administrators to know more easily when the
118
+ archive contins all the files needed for point-in-time recovery.
119
+
116
120
* Create dump tool for write-ahead logs for use in determining
117
121
transaction id for point-in-time recovery
118
122
* Set proper permissions on non-system schemas during db creation
@@ -455,7 +459,7 @@ Commands
455
459
456
460
* COPY
457
461
o Allow COPY to report error lines and continue
458
-
462
+
459
463
This requires the use of a savepoint before each COPY line is
460
464
processed, with ROLLBACK on COPY failure.
461
465
@@ -468,7 +472,7 @@ Commands
468
472
469
473
* CURSOR
470
474
o Allow UPDATE/DELETE WHERE CURRENT OF cursor
471
-
475
+
472
476
This requires using the row ctid to map cursor rows back to the
473
477
original heap row. This become more complicated if WITH HOLD cursors
474
478
are to be supported because WITH HOLD cursors have a copy of the row
@@ -487,7 +491,7 @@ Commands
487
491
o Allow INSERT/UPDATE of the system-generated oid value for a row
488
492
o Allow INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..)
489
493
o Allow INSERT/UPDATE ... RETURNING new.col or old.col
490
-
494
+
491
495
This is useful for returning the auto-generated key for an INSERT.
492
496
One complication is how to handle rules that run as part of
493
497
the insert.
@@ -661,7 +665,7 @@ Exotic Features
661
665
to clients
662
666
* Allow queries across databases or servers with transaction
663
667
semantics
664
-
668
+
665
669
Right now contrib/dblink can be used to issue such queries except it
666
670
does not have locking or transaction semantics. Two-phase commit is
667
671
needed to enable transaction semantics.