11====================================================
22TODO list (FAQ) for PostgreSQL
33====================================================
4- last updated:Wed Jan 29 00:16:44 EST 1997
4+ last updated:Sat Mar 1 21:28:10 EST 1997
55
66current maintainer:Bruce Momjian (maillist@candle.pha.pa.us)
77
@@ -16,6 +16,7 @@ Developers who have claimed items are:
1616Bruce is Bruce Momjian<maillist@candle.pha.pa.us>
1717Bryan is Bryan Henderson<bryanh@giraffe.netgate.net>
1818Dan is Dan McGuirk <mcguirk@indirect.com>
19+ Daniel is Daniel Kalchev <daniel@digsys.bg>
1920Darren is Darren King <darrenk@insightdist.com>
2021Edmund is Edmund Mergl <E.Mergl@bawue.de>
2122Erich Stamberger <eberger@gewi.kfunigraz.ac.at>
@@ -33,17 +34,20 @@ remove -S (stable memory) option or fix memory manager
3334Fix CLUSTER
3435Fix all NULL features
3536allow psql to print nulls meaningfully
36- Fix compile and security of Kerberos V code
37+ Fix compile and security of Kerberos/GSSAPI code (Daniel Kalchev?)
3738Dropping a table twice causes corruption, drop/create not rollback-able
3839-SUM aggregate on no rows or null value should return NULL, not zero(Thomas)
3940SELECT on two tables where zero or one table in WHERE and target
40- clause returns no rows
41- fix system to use oid index using constant without cast to oid
41+ clause returns no rows
4242COUNT on VIEW always returns zero (maybe because there is no oid for views?)
4343CREATE VIEW requires super-user priviledge
4444SELECT a[1] FROM test fails, it needs test.a[1]
4545INSERT INTO ... SELECT DISTINCT ... generates error on DISTINCT
4646pg_database.datdba is oid, should be int4
47+ fix array diffs in regression test
48+ can lo_export()/lo_import() read/write anywhere, causing a security problem?
49+ SELECT ... INTO TABLE ... with varchar()/char() types have zero-length fields
50+ Fix UPDATE key_table SET keyval=max(reftab.NUM)+1 WHERE tblname='reftab'
4751
4852ENHANCEMENTS
4953------------
@@ -63,7 +67,7 @@ Add full ANSI SQL capabilities
6367add domains
6468add sql3 recursive unions
6569add the concept of dataspaces
66- allow conversion type casts onselect target fields
70+ allow conversion type casts onSELECT target fields
6771Allow compression of large fields or a compressed field type
6872Fix the rules system(Jan?)
6973robust
@@ -92,22 +96,21 @@ Add other language types for built-in functions
9296expand to allow tcl, perl, java,
9397generalize the function manager switch to pass
9498function sources to interpreter engines.
95-
96-
97-
98-
99-
100-
99+ remove time-travel feature(Vadim)
100+ reduce system column overhead(Vadmin)
101+ remove pg_time table(Vadim)
102+ allow row re-use without vacuum, maybe?(Vadim)
103+ split apart row removal function from statistics function
104+ can't vacuum large objects
101105Remove restriction that ORDER BY field must be in SELECT list(?)
102106Allow queries about owner of datbases, tables like:
103107 SELECT u.usesysid FROM postgres.pg_user u;
104108DROP AGGREGATE should take in basetype as an arg(Darren)
105109Add word index for text fields, maybe with trigrams, i.e.:
106110 ' (cat | dog) & ! fox ' meaning text has cat or dog, but not fox
107- Add common-sense constant type promotions
111+ - Add common-sense constant type promotions(Bruce)
108112Allow readline-type or editor command editing of multi-line SQL commands
109- Allow pg_dump to dump all databases at a site in one command
110- Allow function result to be used in GROUP BY
113+ -Allow pg_dump to dump all databases at a site in one command(Bruce)
111114Populate backend status area and write program to dump status data
112115Add ALTER TABLE DROP COLUMN feature
113116Remove stale files upon startup(Vivek)
@@ -118,11 +121,13 @@ Allow aggregate for All types, like count(Darren)
118121Improve optimizer plan choice(Darren)
119122Add STDDEV/VARIANCE() function for standard deviation computation/variance
120123Add upper/lower functions
121- - Add table/column/function discription table indexed by oid
124+ Add table/column/function discription table indexed by oid
122125-make all identifiers case-insensitive(Bruce)
123126add pg_type attribute to identify types that need length (bpchar, varchar)
124127add UNIQUE capability to non-btree indexes
125- improve auto-type casting
128+ allow GROUP BY on columns that are functions
129+ add non-ascii collating strings with strcoll() and setlocale()
130+ new DATE routines (Thomas)
126131
127132PERFORMANCE
128133-----------
@@ -136,12 +141,12 @@ Multi-representational types, a la Illustra. For example, have a
136141 objects, when greater than 8K.
137142Use indexes in ORDER BY
138143Profile engine in INSERT's and other operations
139- Speed up hash creation by using btree's fast sort/insert routines
144+ - Speed up hash creation by using btree's fast sort/insert routines(done)
140145Cache most recent query plan(s?)
141146Allow compression of log and meta data
142147Allow LIKE/wildcard matches to use indexes if the wildcard character is not first
143148Add FILLFACTOR to index creation
144- Allow indexes to be used with OR clauses
149+ Allow indexes to be used with OR clauses(Vadim)
145150-Add column optimization statistics to vacuum(Bruce)
146151-Change pg_attribute.attnvals name to attdispursion and change type float4
147152update pg_statistic table to remove operator column
@@ -151,15 +156,10 @@ DOCUMENTATION
151156Update usermanual source
152157remove time-travel in documentation(Bruce)
153158added features used in grammer but not in docs, like :: and CAST
154- add DECLARE manualpages
159+ add DECLARE manualpage
155160
156161PORTABILITY
157162-----------
158- Windows NT port
159- Mariposa project at Berkeley has a person who's working on this
160- Win95 port, use GNU port or remove it?
161- Merge i386_solaris and sparc_solaris into solaris
162- Switch from PORTNAME to individual feature defines (use configure/autoconf?)
163163Change c.h "Index" and "bool" so they do not conflict with c++
164164
165165
@@ -214,6 +214,8 @@ Allow libpq to distinguish between text value '' and null(Bruce)
214214Allow non-postgres users with createdb privs to destroydb's
215215Allow restriction on who can create C functions(Bryan)
216216Allow restriction on who can do backend COPY(Bryan)
217+ Allow system to use oid index using constant without cast to oid(Bruce)
218+ Auto-cast numeric constants to type of non-constant(Bruce)
217219Can shrink tables, pg_time and pg_log(Vadim & Erich)
218220Change debug level 2 to print queries only, changed debug heading layout(Bruce)
219221Change default decimal constant representation from float4 to float8(Bruce)