11====================================================
22TODO list (FAQ) for PostgreSQL
33====================================================
4- last updated:ThuDec 26 23:45:50 EST1996
4+ last updated:ThuJan 2 11:19:41 EST1997
55
66current maintainer:Bruce Momjian (maillist@candle.pha.pa.us)
77
@@ -21,6 +21,7 @@ Developers who have claimed items are:
2121Erich Stamberger <eberger@gewi.kfunigraz.ac.at>
2222Kurt is "Kurt J. Lidl" <lidl@va.pubnix.com>
2323 Martin is Martin S. Utesch <utesch@aut.tu-freiberg.de>
24+ Thomas is Thomas Lockhart <tgl@mythos.jpl.nasa.gov>
2425Vadim is "Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
2526Vivek is Vivek Khera <khera@kci.kciLink.com>
2627
@@ -34,13 +35,11 @@ Fix all NULL features
3435allow psql to print nulls meaningfully
3536Fix compile and security of Kerberos V code
3637Dropping a table twice causes corruption, drop/create not rollback-able
37- SUM aggregate on no rows or null value should return NULL, not zero
38+ - SUM aggregate on no rows or null value should return NULL, not zero(Thomas)
3839SELECT on two tables where zero or one table in WHERE and target
3940clause returns no rows
4041fix system to use oid index using constant without cast to oid
4142COUNT on VIEW always returns zero (maybe because there is no oid for views?)
42- SELECT ... INTO TABLE ... GROUP BY ... generates unlink error
43- if done three times with same INTO TABLE name (failure cleanup problem?)
4443CREATE VIEW requires super-user priviledge
4544
4645ENHANCEMENTS
@@ -117,6 +116,7 @@ Add STDDEV/VARIANCE() function for standard deviation computation/variance
117116Add upper/lower functions
118117-Add table/column/function discription table indexed by oid
119118-make all identifiers case-insensitive(Bruce)
119+ add pg_type attribute to identify types that need length (bpchar, varchar)
120120
121121PERFORMANCE
122122-----------
@@ -138,14 +138,14 @@ Add FILLFACTOR to index creation
138138Allow indexes to be used with OR clauses
139139-Add column optimization statistics to vacuum(Bruce)
140140-Change pg_attribute.attnvals name to attdispursion and change type float4
141+ update pg_statistic table to remove operator column
141142
142143DOCUMENTATION
143144-------------
144145Update usermanual source
145146remove time-travel in documentation(Bruce)
146147added features used in grammer but not in docs, like :: and CAST
147148add DECLARE manual pages
148- add EXPLAIN manual page
149149
150150PORTABILITY
151151-----------
@@ -173,6 +173,7 @@ Fix permissions on lo_export()(Bruce)
173173Fix unitialized reads of memory(Kurt)
174174Fixed ALTER TABLE ... char(3) bug(Bruce)
175175Fixed a few small memory leaks
176+ Fixed EXPLAIN handling of options and changed full_path option name
176177Fixed output of group acl permissions
177178Memory leaks (hunt and destroy with tools like Purify(Kurt)
178179Minor improvements to rules system
@@ -186,12 +187,14 @@ Properly report errors when insert column names were not correct
186187Psql \g filename now works(Bruce)
187188Psql fixed problem with multiple statements on one line with multiple outputs
188189Removed duplicate system oid's
190+ SELECT * INTO TABLE . GROUP/ORDER BY gives unlink error if table exists(Bruce)
189191Several fixes for queries that crashed the backend
190192Starting quote in insert string errors(Bruce)
191193Submiting an empty query now returns empty status, not just " " query(Bruce)
192194
193195Enhancements
194196------------
197+ Add EXPLAIN manual page(Bruce)
195198Add UNIQUE index capability(Dan)
196199Add hostname/user level access control rather than just hostname and user
197200Add synonym of != for <>(Bruce)