11TODO list for PostgreSQL
22========================
3- Last updated:Sun Mar 1 17:14:36 EST 1998
3+ Last updated:Sat Mar21 00:26:29 EST 1998
44
55Current maintainer:Bruce Momjian (maillist@candle.pha.pa.us)
66
@@ -30,7 +30,7 @@ Developers who have claimed items are:
3030* Kurt is "Kurt J. Lidl" <lidl@va.pubnix.com>
3131 * Marc is Marc Fournier <scrappy@hub.org>
3232 * Martin is Martin S. Utesch <utesch@aut.tu-freiberg.de>
33- * Michael is Michael Meskes <meskes@topsystem.de >
33+ * Michael is Michael Meskes <meskes@debian.org >
3434* Oleg is Oleg Bartunov <oleg@sai.msu.su>
3535* Paul is Paul M. Aoki <aoki@CS.Berkeley.EDU>
3636* Patrick is Patrick van Kleef <pvk@pobox.com>
@@ -68,7 +68,6 @@ RELIABILITY
6868* Tables that start with xinv confused to be large objects
6969* Two and three dimmensional arrays display improperly, missing {}
7070* GROUP BY in INSERT INTO table SELECT * FROM table2 fails
71- * lo_unlink() crashes server
7271* Prevent auto-table reference, like SELECT table.col WHERE col = 3 (?)
7372* SELECT * FROM table WHERE int4_column = '1' fails
7473* SELECT a[1] FROM test fails, it needs test.a[1]
@@ -77,6 +76,9 @@ RELIABILITY
7776* User who can create databases can modify pg_database table
7877* optimizer memory exhaustion with many OR's
7978* elog() does not free all its memory(Jan)
79+ * views on subselects fail
80+ * disallow inherited columns with the same name as new columns
81+ * recover or force failure when disk space is exhausted
8082
8183ENHANCEMENTS
8284------------
@@ -86,10 +88,10 @@ ENHANCEMENTS
8688* Allow transaction commits with rollback with no-fsync performance
8789* More access control over who can create tables and access the database
8890* Add full ANSI SQL capabilities
89- * Implement HAVING clause
91+ * Implement HAVING clause(Stephan)
9092* add OUTER joins, left and right (Thomas)
9193* make VIEWs updateable where possible
92- * add INTERSECTS, SUBTRACTS
94+ * add INTERSECTS, SUBTRACTS(Stephan)
9395* add temporary tables(Bruce)
9496* add sql3 recursive unions
9597* add the concept of dataspaces
@@ -106,9 +108,11 @@ ENHANCEMENTS
106108* Large objects
107109* Fix large object mapping scheme, own reltype
108110* not to stuff everything as files in a single directory
111+ * Fix large object memory leaks
109112* Better interface for adding to pg_group
110113* Make MONEY/DECIMAL have a defined precision
111- * Add support for tables >2G, or test current version
114+ * Fix tables >2G, or report error when 2G size reached
115+ (fix lseek()/off_t, mdextend()/RELSEG_SIZE)
112116* Threaded version of the server or libpq
113117* Allow libpq to cancel query requests
114118* Add REGEX internationalization
@@ -135,7 +139,6 @@ ENHANCEMENTS
135139* Allow psql to print nulls as distinct from ""(?)
136140* Allow variable casts with BETWEEN 'today'::asbtime AND 'today'::abstime
137141* Allow INSERT INTO ... SELECT ... FROM view to work
138- * Allow text, char(), and varchar() overhead to be only 2 bytes, not 4 bytes
139142* Make VACUUM on database not lock pg_class
140143* Make VACUUM ANALYZE only use a readlock
141144* Allow cursors to be DECLAREd/OPENed/CLOSEed outside transactions
@@ -145,6 +148,15 @@ ENHANCEMENTS
145148* Allow variable block sizes(Darren)
146149* System tables are now more update-able from SQL(Jan)
147150* New pg_shadow file, pg_user is now a view of pg_shadow(Jan)
151+ * Allow flag to control COPY input/output of NULLs
152+ * Allow CLUSTER on all tables at once, and improve CLUSTER
153+ * Change all references of Postgres to PostgreSQL, including binary names
154+ * Add ELOG_TIMESTAMPS to elog()(?)
155+ * Change LOCK tablename to LOCK TABLE tablename(?)
156+ * Allow max tuple length to be changed(Darren)
157+ * Have psql with no database name not connect to username as default(?)
158+ * Allow subqueries in target list
159+ * Granting permissions to another user looses permissions for the owner
148160
149161PERFORMANCE
150162-----------
@@ -161,19 +173,59 @@ PERFORMANCE
161173* update pg_statistic table to remove operator column
162174* make index creation use psort code, because it is now faster(Vadim)
163175* remove fork()/exec() of backend and make it just fork()
164- * Improve vacuum locking issues
165176* Add base table name to \d index
177+ * Allow char() not to use variable-sized header to reduce disk size
178+ * Do async I/O to do better read-ahead of data
179+ * Fix optmizer problem with self-table joins
180+ * Fix memory exhaustion when using many OR's
181+ * Use spin locks only on multi-CPU systems, yield CPU instead
182+ * Get faster regex() code from Henry Spencer <henry@zoo.utoronto.ca>
183+ when it is available
166184
167185DOCUMENTATION
168186-------------
169187* Update usermanual source(many)
170188* added features used in grammer but not in docs, like :: and CAST
171189* update libpq++ and pginterface manual page
172190* Add keyword list to documentation, already in /tools
191+ * Add 'man pgsql' to show all manual page names
192+
173193
174194
175195=============================================================================
176196
197+ CHANGES IN THE 6.3p1 PATCH
198+ --------------------------
199+ ecpg cleanup/fixes, now version 1.1(Michael Meskes)
200+ pg_user cleanup(Bruce)
201+ large object fix for pg_dump and tclsh(alvin@camberlo.demon.co.uk)
202+ LIKE fix for multiple adjacent underscores
203+ fix for redefining builtin functions(Thomas)
204+ ultrix4 cleanup
205+ upgrade to pg_access 0.83
206+ updated CLUSTER manual page
207+ multi-byte character set support, see doc/README.mb(Tatsuo)
208+ configure --with-pgport fix
209+ pg_ident fix
210+ big-endian fix for backend communications(Tatsuo)
211+ SUBSTR() and substring() fix(Thomas)
212+ several jdbc fixes(Peter)
213+ libpgtcl improvements, see libptcl/README(Randy Kunkee)
214+ Fix for "Datasize = 0" error(Vadim)
215+ Prevent \do from wrapping(Bruce)
216+ Remove duplicate Russian character set entries
217+ Sunos4 cleanup
218+ Allow optional TABLE keyword in LOCK and SELECT INTO(Thomas)
219+ CREATE SEQUENCE options to allow a negative integer(Thomas)
220+ Add "PASSWORD" as an allowed column identifier(Thomas)
221+ Add checks for UNION target fields(Bruce)
222+ Fix Alpha port(Dwayne Bailey)
223+ Fix for text arrays containing quotes(Doug Gibson)
224+ Solaris compile fix(Albert Chin-A-Young)
225+ Better identify tcl and tk libs and includes(Bruce)
226+
227+
228+
177229CHANGES IN THE 6.3 RELEASE
178230--------------------------
179231