11TODO list for PostgreSQL
22========================
3- Last updated:Thu May 10 13:19:40 EDT 2001
3+ Last updated:Thu May 10 13:29:36 EDT 2001
44
55Current maintainer:Bruce Momjian (pgman@candle.pha.pa.us)
66
@@ -47,9 +47,10 @@ URGENT
4747
4848ADMIN
4949
50- * More access control over who can create tables and use locks (Karel)
51- * Allow better control over user privileges [privileges]
52- * Permission to DELETE table allows UPDATE also
50+ * More access control over who can (Karel)
51+ * Improve control over user privileges, including table creation and
52+ lock use [privileges]
53+ * Permission to DELETE table also allows UPDATE
5354* Allow elog() to return error codes, module name, file name, line
5455 number, not just messages [elog]
5556* Allow international error message support and add error codes [elog]
@@ -59,36 +60,35 @@ ADMIN
5960
6061TYPES
6162
62- * Nchar (as distinguished from ordinary varchar),
63- * Domain capability
63+ * Add domain capability
6464* Add IPv6 capability to INET/CIDR types
6565* Add conversion function from text to inet
6666* Make a separate SERIAL type?
6767* Store binary-compatible type information in the system
68- * Allow LOCALE on a per-column basis, default to ASCII
69- * Add SHOW command to see locale
7068* Allow nulls in arrays
7169* Allow arrays to be ORDER'ed
7270* Support construction of array result values in expressions
73- * Change foreign key constraint for array -> element to mean element
74- in array
7571* Remove Money type, add money formatting for decimal type
7672* Declare typein/out functions in pg_proc with a special "C string" data type
7773* Add non-large-object binary field
74+ * Make binary/file in/out interface for TOAST columns
7875* Functions returning sets do not totally work
7976* SELECT col FROM tab WHERE numeric_col = 10.1 fails
8077* Allow better handling of numeric constants, type conversion [typeconv]
78+ * Missing optimizer selectivities for date, r-tree, etc. [optimizer]
79+ * SELECT cash_out(2) crashes because of opaque
80+ * Add SQL standard function bit_length()
81+ * Make oid use unsigned int more reliably, pg_atoi()
82+
83+ MULTILANGUAGE SUPPORT
84+
85+ * Add nchar (as distinguished from ordinary varchar),
86+ * Allow LOCALE on a per-column basis, default to ASCII
87+ * Add SHOW command to see locale
8188* Support multiple simultaneous character sets, per SQL92
8289* Reject character sequences those are not valid in their charset
8390* Make functions more multi-byte aware, i.e. trim()
8491* Make n of CHAR(n)/VARCHAR(n) the number of letters, not bytes
85- * Add btree index support for reltime, tinterval, regproc
86- * Add rtree index support for line, lseg, path, point
87- * Make binary/file in/out interface for TOAST columns
88- * SELECT cash_out(2) crashes because of opaque
89- * Add SQL standard function bit_length()
90- * Make oid use unsigned int more reliably, pg_atoi()
91- * Missing optimizer selectivities for date, r-tree, etc. [optimizer]
9292
9393VIEWS
9494
@@ -109,6 +109,8 @@ INDEXES
109109* Add UNIQUE capability to non-btree indexes
110110* Certain indexes will not shrink, i.e. oid indexes with many inserts (Vadim)
111111* Have UPDATE/DELETE clean out indexes
112+ * Add btree index support for reltime, tinterval, regproc
113+ * Add rtree index support for line, lseg, path, point
112114
113115COMMANDS
114116
@@ -178,6 +180,8 @@ REFERENTIAL INTEGRITY
178180* Add unique indexes on pg_database
179181* Check all system tables and add unique indexes as needed
180182* Make constraints clearer in dump file
183+ * Change foreign key constraint for array -> element to mean element
184+ in array
181185
182186EXOTIC FEATURES
183187