TODO list for PostgreSQL

========================

Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)

* -Array index references without table name cause problems [array](Tom)

* Update table SET table.value = 3 fails(SQL standard says this is OK)

* Creating index of TIMESTAMP & RELTIME fails, or rename to DATETIME(Thomas)

* -INSERT ... SELECT ... GROUP BY groups by target columns not source columns(Tom)

* -CREATE TABLE test (a char(5) DEFAULT text '', b int4) fails on INSERT(Tom)

* -UNION with LIMIT fails

* redesign INSERT ... SELECT to have two levels of target list

* -select * from pg_class where oid in (0,-1)

* have INTERSECT/EXCEPT prevent duplicates unless ALL is specified

* -SELECT COUNT('asdf') FROM pg_class WHERE oid=12 crashes

* SELECT DISTINCT ON col1 col1 col2 FROM tab1 is broken [distinct]

* -require SELECT DISTINCT target list to have all ORDER BY columns

* plpgsql regression tests fails on BSD/OS

* -database names with spaces fail

* insert of 0.0 into DECIMAL(4,4) field fails

ENHANCEMENTS

------------

* Nchar (as distinguished from ordinary varchar),

* Domain capability

* Add STDDEV/VARIANCE() function for standard deviation computation/variance

* Large objects

o Fix large object mapping scheme, own typeid or reltype(Peter)

o Not to stuff everything as files in a single directory, hash dirs

o Allow large object vacuuming

o Tables that start with xinv confused to be large objects

* -Allow flag to control COPY input/output of NULLs

* Update reltuples from COPY command

* -Allow psql \copy to allow delimiters

* -Allow psql to print nulls as distinct from "" [null]

EXOTIC FEATURES

* Put sort files, large objects in their own directory

* Do autocommit so always in a transaction block(?)

* Show location of syntax error in query [yacc]

* -Document/trigger/rule so changes to pg_shadow recreate pg_pwd [pg_shadow]

* Missing optimizer selectivities for date, r-tree, etc. [optimizer]

* -Overhaul mdmgr/smgr to fix double unlinking and double opens, cleanup

* Pull requested data directly from indexes, bypassing heap data

* Use index to restrict rows returned by multi-key index when used with

non-consecutive keys or OR clauses, so fewer heap accesses

* Improve LIMIT processing by using index to limit rows processed [limit]

* Have optimizer take LIMIT into account when considering index scans [limit]

* -Allow creation of sort temp tables > 1 Gig

* -Create more system table indexes for faster cache lookups

* -fix indexscan() so it does leak memory by not requiring caller to

* Cache most recent query plan(s) [prepare]

* Shared catalog cache, reduce lseek()'s by caching table size in shared area

perhaps using invalidation cache

* Get faster regex() code from Henry Spencer <henry@zoo.utoronto.ca>

when it is available

* Use mmap() rather than SYSV shared memory(?)

* Make oid use oidin/oidout not int4in/int4out in pg_type.h

* Improve Subplan list handling

* Allow Subplans to use efficient joins(hash, merge) with upper variable