1
1
====================================================
2
2
TODO list (FAQ) for PostgreSQL
3
3
====================================================
4
- last updated: Thu Dec 26 23:45:50 EST 1996
4
+ last updated: Thu Jan 2 11:19:41 EST 1997
5
5
6
6
current maintainer: Bruce Momjian (maillist@candle.pha.pa.us)
7
7
@@ -21,6 +21,7 @@ Developers who have claimed items are:
21
21
Erich Stamberger <eberger@gewi.kfunigraz.ac.at>
22
22
Kurt is "Kurt J. Lidl" <lidl@va.pubnix.com>
23
23
Martin is Martin S. Utesch <utesch@aut.tu-freiberg.de>
24
+ Thomas is Thomas Lockhart <tgl@mythos.jpl.nasa.gov>
24
25
Vadim is "Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
25
26
Vivek is Vivek Khera <khera@kci.kciLink.com>
26
27
@@ -34,13 +35,11 @@ Fix all NULL features
34
35
allow psql to print nulls meaningfully
35
36
Fix compile and security of Kerberos V code
36
37
Dropping 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)
38
39
SELECT on two tables where zero or one table in WHERE and target
39
40
clause returns no rows
40
41
fix system to use oid index using constant without cast to oid
41
42
COUNT 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?)
44
43
CREATE VIEW requires super-user priviledge
45
44
46
45
ENHANCEMENTS
@@ -117,6 +116,7 @@ Add STDDEV/VARIANCE() function for standard deviation computation/variance
117
116
Add upper/lower functions
118
117
-Add table/column/function discription table indexed by oid
119
118
-make all identifiers case-insensitive(Bruce)
119
+ add pg_type attribute to identify types that need length (bpchar, varchar)
120
120
121
121
PERFORMANCE
122
122
-----------
@@ -138,14 +138,14 @@ Add FILLFACTOR to index creation
138
138
Allow indexes to be used with OR clauses
139
139
-Add column optimization statistics to vacuum(Bruce)
140
140
-Change pg_attribute.attnvals name to attdispursion and change type float4
141
+ update pg_statistic table to remove operator column
141
142
142
143
DOCUMENTATION
143
144
-------------
144
145
Update usermanual source
145
146
remove time-travel in documentation(Bruce)
146
147
added features used in grammer but not in docs, like :: and CAST
147
148
add DECLARE manual pages
148
- add EXPLAIN manual page
149
149
150
150
PORTABILITY
151
151
-----------
@@ -173,6 +173,7 @@ Fix permissions on lo_export()(Bruce)
173
173
Fix unitialized reads of memory(Kurt)
174
174
Fixed ALTER TABLE ... char(3) bug(Bruce)
175
175
Fixed a few small memory leaks
176
+ Fixed EXPLAIN handling of options and changed full_path option name
176
177
Fixed output of group acl permissions
177
178
Memory leaks (hunt and destroy with tools like Purify(Kurt)
178
179
Minor improvements to rules system
@@ -186,12 +187,14 @@ Properly report errors when insert column names were not correct
186
187
Psql \g filename now works(Bruce)
187
188
Psql fixed problem with multiple statements on one line with multiple outputs
188
189
Removed duplicate system oid's
190
+ SELECT * INTO TABLE . GROUP/ORDER BY gives unlink error if table exists(Bruce)
189
191
Several fixes for queries that crashed the backend
190
192
Starting quote in insert string errors(Bruce)
191
193
Submiting an empty query now returns empty status, not just " " query(Bruce)
192
194
193
195
Enhancements
194
196
------------
197
+ Add EXPLAIN manual page(Bruce)
195
198
Add UNIQUE index capability(Dan)
196
199
Add hostname/user level access control rather than just hostname and user
197
200
Add synonym of != for <>(Bruce)
0 commit comments