6.5 TODO list - Mailing list pgsql-hackers

OK, here is the list.  Please send me changes.  I will post this
periodically.  I realize many are not show-stoppers, but it doesn't hurt
to have everyone see the items.  I will move them to the main TODO list
as we get closer to final.

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


Can not insert/update oid
Default of '' causes crash in some cases
EXPLAIN SELECT 1 UNION SELECT 2 crashes, rewrite system?
shift/reduce conflict in grammar, SELECT ... FOR [UPDATE|CURSOR]
move UNION stuff into rewrite files
CLUSTER failure if vacuum has not been performed in a while
Do we want pg_dump -z to be the default?
Improve Subplan list handling
Allow Subplans to use efficient joins(hash, merge) with upper variable
Improve NULL parameter passing into functions
Table with an element of type inet, will show "0.0.0.0/0" as "00/0"
When creating a table with either type inet or type cidr as a primary,unique  key, the "198.68.123.0/24" and
"198.68.123.0/27"are considered equal
 
store binary-compatible type information in the system somewhere 
create table "AA" ( x int4 , y serial ); insert into "AA" (x) values (1); fails
add ability to add comments to system tables using table/colname combination
improve handling of oids >2 gigs by making unsigned int usage consistentoidin, oidout, pg_atoi
Allow ESCAPE '\' at the end of LIKE for ANSI compliance, or rewrite theLIKE handling by rewriting the user string with
thesupplied ESCAPE
 
Vacuum of tables >2 gigs - NOTICE:  Can't truncate multi-segments relation
Make Serial its own type?
Add support for & operator
Fix leak for expressions?, aggregates?
Remove ERROR:  check_primary_key: even number of arguments should be specified
make oid use oidin/oidout not int4in/int4out in pg_type.h
missing optimizer selectivities for date, etc.
process const=const parts of OR clause in separate pass
improve LIMIT processing by using index to limit rows processed
int8 indexing needs work?
Allow "col AS name" to use name in WHERE clause?  Is this ANSI? Works in GROUP BY
Update reltuples from COPY command
hash on int2/char only looks a first bytes, and big-endian machines hash poorly
Docs for INSERT INTO/SELECT INTO fix
Some CASE() statements involving two tables crash
Trigger regression test fails
CREATE FUNCTION fails
nodeResults.c and parse_clause.c give compiler warnings
Markup sql.sgml, Stefan's intro to SQL
Markup cvs.sgml, cvs and cvsup howto
Add figures to sql.sgml and arch-dev.sgml, both from Stefan
Include Jose's date/time history in User's Guide (neat!)
Generate Admin, User, Programmer hardcopy postscript
move LIKE index optimization handling to the optimizer?
DROP TABLE/RENAME TABLE doesn't remove extended files, *.1, *.2
CREATE VIEW ignores DISTINCT?
ORDER BY mixed with DISTINCT causes duplicates
select * from test where test in (select * from test) fails with strange error
MVCC locking, deadlock, priorities?
Make sure pg_internal.init generation can't cause unreliability
SELECT ... WHERE col ~ '(foo|bar)' works, but CHECK on table always fails
GROUP BY expression?
CREATE TABLE t1 (a int4, b int4); CREATE VIEW v1 AS SELECT b, count(b)FROM t1 GROUP BY b; SELECT count FROM v1; fails
CREATE INDEX zman_index ON test (date_trunc( 'day', zman ) datetime_ops) failsindex can't store constant parameters,
allowSQL function indexes?
 
pg_dump of groups problem
select 1; select 2 fails when sent not via psql, semicolon problem
create operator *= (leftarg=_varchar, rightarg=varchar, procedure=array_varchareq); fails, varchar is reserved word,
quoteswork
 
have hashjoins use portals, not fixed-size memory
pg_dump -o -D does not work, and can not work currently, generate error?
problem with ALTER TABLE on inherited
pg_dump does not preserver NUMERIC precision, psql \d should show precision
DROP TABLE leaves INDEX file descriptor open
pg_interal.init, check for reliability on rebuild
ALTER TABLE ADD COLUMN to inherited table put column in wrong place
dumping out sequences should not be counted in pg_dump display
GROUP BY can reference columns not in target list
SELECT name, value FROM t1 as touter WHERE (value/(SELECT AVG(value) FROM t1 WHERE name = touter.name)) > 0.75; fails
resno's, sublevelsup corrupt when reaching rewrite system
crypt_loadpwdfile() is mixing and (mis)matching memory allocation protocols, trying to use pfree() to release pwd_cache
vectorfrom realloc()
 
3 = sum(x) in rewrite system is a problem


--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026