11====================================================
22TODO list (FAQ) for PostgreSQL
33====================================================
4- last updated:Tue Jun 3 16:22:07 EDT 1997
4+ last updated:Tue Jun 3 16:30:57 EDT 1997
55
66current maintainer:Bruce Momjian (maillist@candle.pha.pa.us)
77
@@ -52,7 +52,6 @@ CREATE VIEW requires super-user priviledge
5252SELECT a[1] FROM test fails, it needs test.a[1]
5353INSERT INTO ... SELECT DISTINCT ... generates error on DISTINCT
5454pg_database.datdba is oid, should be int4
55- fix array diffs in regression test
5655can lo_export()/lo_import() read/write anywhere, causing a security problem?
5756-SELECT ... INTO TABLE ... with varchar()/char() types have zero-length fields
5857Fix UPDATE key_table SET keyval=max(reftab.NUM)+1 WHERE tblname='reftab'
@@ -116,7 +115,7 @@ can't reduce index file size with vacuum
116115Remove restriction that ORDER BY field must be in SELECT list(?)
117116Allow queries about owner of datbases, tables like:
118117 SELECT u.usesysid FROM postgres.pg_user u;
119- DROP AGGREGATE should take in basetype as an arg(Darren)
118+ - DROP AGGREGATE should take in basetype as an arg(Darren)
120119Add word index for text fields, maybe with trigrams, i.e.:
121120 ' (cat | dog) & ! fox ' meaning text has cat or dog, but not fox
122121-Add common-sense constant type promotions(Bruce)
@@ -128,7 +127,7 @@ Remove stale files upon startup(Vivek)
128127Add command to show privileges
129128Allow INSERT INTO ... SELECT to convert column types
130129Add syslog functionality
131- Allow aggregate for all types, like count(Darren)
130+ - Allow aggregate for all types, like count(Darren)
132131Improve optimizer plan choice(Darren)
133132Add STDDEV/VARIANCE() function for standard deviation computation/variance
134133Add table/column/function discription table indexed by oid
@@ -162,7 +161,7 @@ Allow LIKE/wildcard matches to use indexes if the wildcard character is not firs
162161Add FILLFACTOR to index creation
163162Allow indexes to be used with OR clauses(Vadim)
164163-Add column optimization statistics to vacuum(Bruce)
165- - Change pg_attribute.attnvals name to attdispursion and change type float4
164+ Change pg_attribute.attnvals name to attdispursion and change type float4
166165update pg_statistic table to remove operator column
167166
168167DOCUMENTATION
@@ -174,7 +173,6 @@ add DECLARE manual page
174173
175174PORTABILITY
176175-----------
177- Change c.h "Index" and "bool" so they do not conflict with c++
178176
179177
180178---------------------------------------------------------------------------