pgsql-server/doc TODO - Mailing list pgsql-committers

CVSROOT:    /cvsroot
Module name:    pgsql-server
Changes by:    momjian@postgresql.org    02/11/06 00:55:14

Modified files:
    doc            : TODO

Log message:
    Remove completed items:

    < A dash (-) marks changes that will appear in the upcoming 7.3 release.
    > A dash (-) marks changes that will appear in the upcoming 7.4 release.
    38d37
    < * -Change DEBUG startup tag to LOG (Bruce)
    40,51d38
    < * -Add pg_backend_pid() function to backend
    < * -Allow logging of query durations
    <
    <
    < Permissions
    < ===========
    <
    < * -Improve control over user privileges, including table creation
    < * -Allow user/group names to be specified directly in pg_hba.conf (Bruce)
    < * -Add ~/.pgpass to store passwords with user/host/password combinations
    < * -Allow permissions for functions (Peter E)
    < * -Allow object creation to be disabled for specific users
    58,60d44
    < * -Make it easier to create a database owned by someone who can't createdb,
    <   perhaps CREATE DATABASE dbname WITH OWNER = "user" (Gavin)
    < * -Make equals sign optional in CREATE DATABASE WITH param = 'val'
    65,66d48
    < * -Prevent SIGHUP and 'pg_ctl reload' from changing command line
    <   specified parameters to postgresql.conf defaults (Peter E)
    69,70d50
    < * -Reserve last few process slots for super-user if max_connections reached
    < * -Add GUC parameter to print queries that generate errors
    79d58
    < * -Add domain capability (Rod Taylor)
    82,84d60
    < * -SELECT cash_out(2) crashes because of opaque
    < * -Declare typein/out functions in pg_proc with a special "C string" data type
    < * -Functions returning sets do not totally work
    89d64
    < * -Add GUC parameter for DATESTYLE
    91,93d65
    < * -Allow bytea to handle LIKE with non-TEXT patterns
    < * -to_char(0,'FM999.99') returns a period, to_char(1,'FM999.99') doesn't (Karel)
    < * -Add floor(float8) and other missing functions
    97d68
    <     o -Store binary-compatible type information in the system
    104d74
    <     o -Ensure we have array-eq operators for every built-in array type
    139,140d108
    < * -Remove brackets as multi-statement rule grouping, must use parens (Bruce)
    < * -Prevent aggregates from being used in rule WHERE clauses
    154d121
    < * -Allow UPDATE/DELETE on inherited table
    166d132
    < * -Add deleted bit to index tuples to reduce heap access
    176d141
    < * -Test hash index performance and discourage usage
    182d146
    < * -Add SIMILAR TO to allow character classes, 'pg_[a-c]%'
    184d147
    < * -Remove LIMIT #,# and force use LIMIT and OFFSET clauses in 7.3 (Bruce)
    186,187d148
    < * -Disallow TRUNCATE on tables that are involved in referential constraints
    < * -Add OR REPLACE clauses to non-FUNCTION object creation
    190d150
    < * -Prevent create/drop scripts from allowing extra args (Bruce)
    201,205d160
    <     o -Add ALTER TABLE DROP COLUMN feature
    <     o -Add ALTER TABLE DROP non-CHECK CONSTRAINT
    <     o -ALTER TABLE ADD PRIMARY KEY (Tom)
    <     o -ALTER TABLE ADD UNIQUE (Tom)
    <     o -ALTER TABLE ALTER COLUMN SET/DROP NOT NULL (Christopher)
    210d164
    <     o -Have ALTER TABLE OWNER change all dependant objects like indexes
    214,216d167
    <     o -Cluster all tables at once using pg_index.indisclustered set during
    <           previous CLUSTER
    <     o -Prevent loss of indexes, permissions, inheritance
    221d171
    <     o -Allow specification of column names
    224d173
    <     o -Change syntax to WITH DELIMITER, (keep old syntax around?)
    228d176
    <     o -Generate failure on short COPY lines rather than pad NULLs
    242,243d189
    <     o -Allow INSERT INTO my_table VALUES (a, b, c, DEFAULT, x, y, z, ...)
    <     o -Disallow missing columns in INSERT ... (col) VALUES, per ANSI
    248,249d193
    <     o -Add command to display locks
    <     o -Add SET or BEGIN timeout parameter to cancel query
    251d194
    <     o -Remove SET KSQO option now that OR processing is improved (Bruce)
    254,256d196
    <     o -Add SHOW command to see locale
    <     o -Allow SHOW to output as a query result, like EXPLAIN
    <     o -Abort all SET changes made in an aborted transaction
    264d203
    <     o -Fix PL/PgSQL to handle quoted mixed-case identifiers
    287,291d225
    < * -Have pg_dump use LEFT OUTER JOIN in multi-table SELECTs
    <   or multiple SELECTS to avoid bad system catalog entries
    < * -Have pg_dump -C dump database location and encoding information
    < * -Allow psql \d to show foreign keys
    < * -Allow psql \d to show temporary table structure (Tom)
    294d227
    < * -Have pg_dump use ADD PRIMARY KEY after COPY, for performance (Neil)
    302d234
    <     o -Updateable resultSet
    307d238
    <     o -Implement cancel() method on Statement
    309d239
    <         o -Add support for CallableStatements
    311d240
    <     o -Compile under jdk 1.4
    334d262
    < * -Allow oid to act as a foreign key
    337,338d264
    < * -Allow user to control trigger firing order (Tom)
    < * -Add ALTER TRIGGER ... RENAME
    341d266
    < * -Fix foreign key constraints to not error on intermediate db states (Stephan)
    350,359d274
    < * -Add pg_depend table for dependency recording; use sysrelid, oid,
    <   depend_sysrelid, depend_oid, name
    < * -Auto-destroy sequence on DROP of table with SERIAL; perhaps a separate
    <   SERIAL type
    < * -Prevent column dropping if column is used by foreign key
    < * -Propagate column or table renaming to foreign key constraints
    < * -Automatically drop constraints/functions when object is dropped
    < * -Make foreign key constraints clearer in dump file
    < * -Make other constraints clearer in dump file
    < * -Make foreign keys easier to identify
    367d281
    < * -Allow autocommit so always in a transaction block
    377d290
    < * -Add SQL92 schemas (Tom)
    400d312
    < * -Cache most recent query plan(s) (Neil) [prepare]
    439d350
    < * -Cache system catalog information in per-database files (Tom)
    450,451d360
    < * -Reorder postgresql.conf WAL items in order of importance (Bruce)
    < * -Remove wal_files postgresql.conf option because WAL files are now recycled
    465,466d373
    < * -Improve dynamic memory allocation by introducing tuple-context memory
    <   allocation (Tom)
    468d374
    < * -Nested FULL OUTER JOINs don't work (Tom)
    470,472d375
    < * -Add new pg_proc cachable settings to specify whether function can be
    <   evaluated only once or once per query
    < * -Change FIXED_CHAR_SEL to 0.20 from 0.04 to give better selectivity (Bruce)
    494,496d396
    < * -Add Intimate Shared Memory(ISM) for Solaris
    < * -Use faster flex flags for performance improvement (Peter E)
    < * -Add BSD-licensed qsort() for Solaris
    503,507d402
    < * -Fix problems with libpq non-blocking/async code
    < * -Make sure all block numbers are unsigned to increase maximum table size
    < * -Merge LockMethodCtl and LockMethodTable into one shared structure (Bruce)
    < * -HOLDER/HOLDERTAB rename to PROCLOCK/PROCLOCKTAG (Bruce)
    < * -Remove LockMethodTable.prio field, not used (Bruce)
    512,513d406
    < * -Make one version of simple_prompt() in code (Bruce, Tom)
    < * -Compile in syslog functionaility by default (Tatsuo)
    517d409
    < * -Report failure to find readline or zlib at end of configure run
    519,520d410
    < * -Increase identifier length (NAMEDATALEN) if small performance hit,
    < * -Increase maximum number of function parameters if little wasted space
    529,530d418
    < * -Fix glibc's mktime() to handle pre-1970's dates
    < * -Move /contrib/retep to gborg.postgresql.org