• Bruce Momjian's avatar
    Remove completed TODO items: · aa3f396a
    Bruce Momjian authored
    < * -Make postmater and postgres options distinct so the postmaster -o
    <   option is no longer needed
    < * -Allow pooled connections to list all prepared statements
    <
    <   This would allow an application inheriting a pooled connection to know
    <   the statements prepared in the current session.
    <
    < * -Re-enable the GUC full_page_writes in 8.2 when reliability issues have
    <   been addressed
    < 	o -Add "include file" functionality in postgresql.conf
    < 	o -Allow per-database permissions to be set via GRANT
    <
    < 	  Allow database connection checks based on GRANT rules in
    < 	  addition to the existing access checks in pg_hba.conf.
    <
    < 	o -Issue a warning if a change-on-restart-only postgresql.conf value
    > 	o Issue a warning if a change-on-restart-only postgresql.conf value
    < 	  o -Automatically force archiving of partially-filled WAL files when
    < 	    pg_stop_backup() is called or the server is stopped
    < 	  o -Add reporting of the current WAL file and offset, perhaps as
    < 	    part of partial log file archiving
    < * -Allow server logs to be remotely read and removed using SQL commands
    < * -Allow protocol-level BIND parameter values to be logged
    < * -Zero umasked bits in conversion from INET cast to CIDR
    < * -Prevent INET cast to CIDR from dropping netmask, SELECT '1.1.1.1'::inet::cidr
    < * -Allow INET + INT8 to increment the host part of the address or
    <   throw an error on overflow
    < * -Add 'tid != tid ' operator for use in corruption recovery
    < 	o -Allow customization of the known set of TZ names (generalize the
    < 	  present australian_timezones hack)
    < 	o -Allow timezone names in SQL strings, '2006-05-24 21:11
    < 	   Americas/New_York'::timestamptz
    < 		o -Add support for day-time syntax, INTERVAL '1 2:03:04' DAY TO
    < 		  SECOND
    < 	o -Allow NULLs in arrays
    < * -Add transaction_timestamp(), statement_timestamp(), clock_timestamp()
    <   functionality
    <
    <   Current CURRENT_TIMESTAMP returns the start time of the current
    <   transaction, and gettimeofday() returns the wallclock time. This will
    <   make time reporting more consistent and will allow reporting of
    <   the statement start time.
    <
    < * -Allow to_char() to print localized month names
    < * -Add sleep() function, remove from regress.c
    < * -Allow user-defined functions retuning a domain value to enforce domain
    <   constraints
    < * -Allow TRUNCATE ... CASCADE/RESTRICT
    <
    <   This is like DELETE CASCADE, but truncates.
    <
    < * -Add COMMENT ON for all cluster global objects (roles, databases
    <   and tablespaces)
    < * -Make row-wise comparisons work per SQL spec
    <
    <   Right now, '(a, b) < (1, 2)' is processed as 'a < 1 and b < 2', but
    <   the SQL standard requires it to be processed as a column-by-column
    <   comparison, so the proper comparison is '(a < 1) OR (a = 1 AND b < 2)'.
    <
    < * -Enable escape_string_warning and standard_conforming_strings
    > * Enable standard_conforming_strings
    < 	o -Add ON COMMIT capability to CREATE TABLE AS ... SELECT
    < 	o -Allow an alias to be provided for the target table in
    < 	  UPDATE/DELETE (Neil)
    < 	o -Allow UPDATE tab SET ROW (col, ...) = (val, ...) for updating
    < 	  multiple columns
    < 	o -Add ALTER TABLE tab INHERIT / NO INHERIT  parent
    < 	o -Have COPY return the number of rows loaded/unloaded?
    < 	o -Allow COPY (SELECT ...) TO 'filename'
    <
    < 	o -Allow pooled connections to list all open WITH HOLD cursors
    <
    < 	  Because WITH HOLD cursors exist outside transactions, this allows
    < 	  them to be listed so they can be closed.
    <
    < 	o -Allow INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..)
    < 	o -Allow INSERT/UPDATE ... RETURNING new.col or old.col
    < 		o -Allow PL/python to return composite types and result sets
    <
    < * -Have initdb set the input DateStyle (MDY or DMY) based on locale
    < 	o -Improve psql's handling of multi-line statements
    <
    < 	  Currently, while \e saves a single statement as one entry, interactive
    < 	  statements are saved one line at a time.  Ideally all statements
    < 	  would be saved like \e does.
    <
    < 	o -Allow multi-line column values to align in the proper columns
    <
    < 	  If the second output column value is 'a\nb', the 'b' should appear
    < 	  in the second display column, rather than the first column as it
    < 	  does now.
    <
    < 	o -Display IN, INOUT, and OUT parameters in \df
    < 	o -Allow pg_dump to use multiple -t and -n switches, exclusion
    < 	   ability, and regular expression object matching
    < 	o -Update pg_dump and psql to use the new COPY libpq API (Christopher)
    < 	o -Add a function to support Parse/DescribeStatement capability
    < * -Add fillfactor to control reserved free space during index creation
    < * -Add system view to show free space map contents
    < * -Allow installing to directories containing spaces
    <
    <   This is possible if proper quoting is added to the makefiles for the
    <   install targets.  Because PostgreSQL supports relocatable installs, it
    <   is already possible to install into a directory that doesn't contain
    <   spaces and then copy the install to a directory with spaces.
    <
    < * -%Clean up compiler warnings (especially with gcc version 4)
    < * -Remove BeOS and QNX-specific code
    < 	o -Port contrib/xml2
    aa3f396a
TODO 52.6 KB