TODO list for PostgreSQL

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

Last updated:Sun Sep26 23:23:58 EDT 1999

Last updated:Mon Sep27 11:20:02 EDT 1999

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

* Select a[1] FROM test fails, it needs test.a[1]

*-Select a[1] FROM test fails, it needs test.a[1]

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

* Update table SET table.value = 3 fails

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

* 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]

* -When using aggregates + GROUP BY, no rows in should yield no rows out

VIEWS

* Better interface for adding to pg_group

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

*Add syslog functionality

*Test syslog functionality

* 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]

* Generate error on CREATE OPERATOR of ~~, ~ and and ~*

* 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]

* Move LIKE index optimization handling to the optimizer

*-Move LIKE index optimization handling to the optimizer

* 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]

* PQrequestCancel() be able to terminate backend waiting for lock

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

* Convert function(constant) into a constant for index use

*-Convert function(constant) into a constant for index use

* 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)

* Allow SELECT * FROM tab WHERE int2col = 4 use int2col index, int8 too

[optimizer]

* Allow optimizer to prefer plans that match ORDER BY

* Allow SELECT * FROM tab WHERE int2col = 4 use int2col index, int8,

float4, numeric/decimal too[optimizer]

*-Allow optimizer to prefer plans that match ORDER BY

CACHE

MISC

* Allow compression of log and meta data

* Update pg_statistic table to remove operator column

* 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(?)

* Process const = const parts of OR clause in separate pass

*-Process const = const parts of OR clause in separate pass

* 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

* change VACUUM ANALYZE to use btree comparison functions, not <,=,> calls

* 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?

* Remove SET KSQO option if OR processing is improved

* Remove SET KSQO option if OR processing is improved(Tom)

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