TODO list for PostgreSQL

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

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

* SELECT pg_class FROM pg_class generates strange error

* Alter TABLE ADD COLUMN does not honor DEFAULT, add CONSTRAINT

* Do not allow bpchar column creation without length

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

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

* SELECT foo UNION SELECT foo is incorrectly simplified to SELECT foo

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

* prevent primary key of nine columns [primary]

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

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

VIEWS

* Better interface for adding to pg_group

* More access control over who can create tables and access the database

* Allow elog() to return error codes, not just messages

* Allow international error message support and add error codes

* Generate postmaster pid file and remove flock/fcntl lock code [flock]

* Add ALTER TABLE DROP/ALTER COLUMN feature

* Allow CLUSTER on all tables at once, and improve CLUSTER, loses NOT

NULL specification on table [cluster]

* Add SIMILAR TO to allow character classes, 'pg_[a-c]%'

* Auto-destroy sequence on DROP of table with SERIAL(Ryan)

* Allow LOCK TABLE tab1, tab2, tab3 so all tables locked in unison

* Allow INSERT/UPDATE of system-generated oid value for a row

* Allow ESCAPE '\' at the end of LIKE for ANSI compliance [like]

* Rewrite the LIKE handling by rewriting the user string with the

supplied ESCAPE [like]

* Allow RULE recompilation

* Support UNION/INTERSECT/EXCEPT in sub-selects

* Allow psql \copy to allow delimiters

* Add a function to return the last inserted oid, for use in psql scripts

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

EXOTIC FEATURES

* 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

* Allow LIMIT ability on single-table queries that have no ORDER BY to use

a matching index [limit]

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

* Create more system table indexes for faster cache lookups

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

* Improve _bt_binsrch() to handle equal keys better, remove _bt_firsteq()(Tom)

CACHE

MISC

* Allow compression of log and meta data

* Allow char() not to use variable-sized header to reduce disk size

* Do async I/O to do better read-ahead of data

* -Fix memory exhaustion when using many OR's [cnfify]

* 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

* In WHERE tab1.x=3 AND tab1.x=tab2.y, add tab2.y=3

* pass atttypmod through parser in more cases [atttypmod]

* remove duplicate type in/out functions for disk and net

* Allow persistent backends [persistent]

* Misc [performance]

* -Add needed includes and removed unneeded include files(Bruce)

* Make configure --enable-debug add -g on compile line

* Does Mariposa source contain any other bug fixes?

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