TODO list for PostgreSQL

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

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

* Remove EXTEND?

* Can lo_export()/lo_import() read/write anywhere, causing a security problem?

* Tables that start with xinv confused to be large objects

* GROUP BY in INSERT INTO table SELECT * FROM table2 fails

* Prevent auto-table reference, like SELECT table.col WHERE col = 3 (?)

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

* UPDATE table SET table.value = 3 fails

* User who can create databases can modify pg_database table

* views on subselects fail

* disallow inherited columns with the same name as new columns

* recover or force failure when disk space is exhausted

* allow UPDATE using aggregate to affect all rows, not just one

* computations in views fail:

create view test as select usesysid * usesysid from pg_shadow;

* views containing aggregates sometimes fail(Jan)

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

* fix memory leak in aborted transactions

* array index references without table name cause problems

* aggregates on array indexes crash backend

* add temporary tables

* add sql3 recursive unions

* add the concept of dataspaces

* NCHAR (as distinguished from ordinary varchar),

* DOMAIN capability

* Allow compression of large fields or a compressed field type

* Fix the rules system(Jan,Soo-Ho)

* Large objects

* Fix large object mapping scheme, own reltype(Peter)

* Allow large text type to use large objects(Peter)

(fix lseek()/off_t, mdextend()/RELSEG_SIZE)

* Add REGEX internationalization

* allow row re-use without vacuum, maybe?(Vadim)

* Populate backend status area and write program to dump status data

* Add ALTER TABLE DROP/ALTER COLUMN feature

* Add syslog functionality(Marc)

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

* add UNIQUE capability to non-btree indexes

* make NULL's come out at the beginning or end depending on the ORDER BY direction

* change the library/backend interface to use network byte order

* Restore unused oid's on backend exit if no one else has gotten oids

* have UPDATE/DELETE clean out indexes

* allow WHERE restriction on ctid

* allow pg_descriptions when creating types, tables, columns, and functions

* Fix compile and security of Kerberos/GSSAPI code

* Allow psql to print nulls as distinct from ""(?)

* Allow INSERT INTO ... SELECT ... FROM view to work

* Make VACUUM on database not lock pg_class

* Make VACUUM ANALYZE only use a readlock

* New pg_shadow file, pg_user is now a view of pg_shadow(Jan)

* Allow flag to control COPY input/output of NULLs

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

* Add ELOG_TIMESTAMPS to elog()(?)

* Allow max tuple length to be changed(Darren)

* Have psql with no database name not connect to username as default(?)

* Allow subqueries in target list

* multi-verion concurrency control(Vadim)

* improve reporting of syntax errors by showing location of error in query

* allow chaining of pages to allow >8k tuples

* redesign the function call interface to handle NULLs better(Jan)

* permissions on indexes - prevent them?

* allow multiple generic operators in expressions without the use of parentheses

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

* Update usermanual source(many)

* added features used in grammer but not in docs, like :: and CAST

* Add 'man pgsql' to show all manual page names

* Add use of 'const' for varibles in source tree

CHANGES IN THE 6.4.1 RELEASE

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

Add pg_dump -N flag to force double quotes around identifiers. This is

Fix for NOT in where clause causing crash(Bruce)

EXPLAIN VERBOSE coredump fix(Vadim)

Fix shared-library problems on Linux

Fix test for table existance to allow mixed-case and whitespace in

Fix a couple of pg_dump bugs

Configure matches template/.similar entries better(Tom)

Change builtin function names from SPI_* to spi_*

OR WHERE clause fix(Vadim)

Fixes for mixed-case table names(Billy)

libpq memory overrun fix

SunOS fixes(Tom)

pg_dump fixes for memory leak, inheritance constraints, layout change

update pgaccess to 0.93

Fix prototype for 64-bit platforms

Better search for install program(Tom)

Timezone fixes(Tom)

HPUX fixes(Tom)

Add routines to help with single-byte (internal) character type(Thomas)

Compilation of libpq for Win32 fixes(Magnus)

Upgrade to PyGreSQL 2.2(D'Arcy)