• Bruce Momjian's avatar
    Cleaups: · 6cd67c93
    Bruce Momjian authored
    < * Allow GRANT/REVOKE permissions to be given to all schema objects with one
    > * Allow GRANT/REVOKE permissions to be applied to all schema objects with one
    60c60
    <   specifications.  This is because new databases are created by copying
    >   specifications.  This is because new databases are created by copying
    63c63
    <   directory would create a new database with tables that had incorrect
    >   directory would create a new database with tables that had incorrect
    72c72
    <
    >
    85c85
    <   By not showing commented-out variables, we discourage people from
    >   By not showing commented-out variables, we discourage people from
    91c91
    < * Allow point-in-time recovery to archive partially filled write-ahead
    > * Allow point-in-time recovery to archive partially filled write-ahead
    102c102
    <   Currently all schemas are owned by the super-user because they are
    >   Currently all schemas are owned by the super-user because they are
    128c128
    < * Allow INET subnet tests with non-constants to be indexed
    > * Allow INET subnet tests using non-constants to be indexed
    143,144c143,144
    < * Allow to_char to print localized month names
    < * Allow functions to have a search path specified at creation time
    > * Allow to_char() to print localized month names
    > * Allow functions to have a schema search path specified at creation time
    146c146
    < * Add GUC variable to allow output of interval values in ISO8601 format
    > * Add a GUC variable to allow output of interval values in ISO8601 format
    154,155c154,155
    < * Prevent inet cast to cidr if the unmasked bits are not zero, or
    <   zero bits
    > * Prevent INET cast to CIDR if the unmasked bits are not zero, or
    >   zero the bits
    158c158
    < 	o Allow nulls in arrays
    > 	o Allow NULLs in arrays
    160,161c160,161
    < 	o Delay resolution of array expression type so assignment coercion
    < 	  can be performed on empty array expressions
    > 	o Delay resolution of array expression's data type so assignment
    > 	  coercion can be performed on empty array expressions
    218,219c218,219
    <   key, foreign key  [inheritance]
    < * UNIQUE INDEX on base column not honored on inserts/updates from
    >   key, foreign key
    > * UNIQUE INDEX on base column not honored on INSERTs/UPDATEs from
    221c221
    <   (dup) should fail [inheritance]
    >   (dup) should fail
    246c246
    < * Fetch heap pages matching index entries in sequential order [performance]
    > * Fetch heap pages matching index entries in sequential order
    307c307
    <   functionality in DELETE.  It's been agreed that the keyword should
    >   functionality in DELETE.  It's been agreed that the keyword should
    318c318
    < * Allow PREPARE to automatically determine parameter types based on the SQL
    > * Allow PREPARE to automatically determine parameter types based on the SQL
    340,342d339
    < * Allow CREATE TABLE foo (f1 INT CHECK (f1 > 0) CHECK (f1 < 10)) to work
    <   by searching for non-conflicting constraint names, and prefix with
    <   table name?
    347c344
    <   new database.
    >   a new database.
    350,351d346
    < * Ignore temporary tables from other sessions when processing
    <   inheritance?
    354,355c349,351
    < * Add a session mode to warn about non-standard SQL usage in queries
    < * Add MERGE command that does UPDATE/DELETE, or on failure, INSERT (rules, triggers?)
    > * Add a GUC variable to warn about non-standard SQL usage in queries
    > * Add MERGE command that does UPDATE/DELETE, or on failure, INSERT (rules,
    >   triggers?)
    357,359c353,356
    < * Add NOVICE output level for helpful messages like automatic sequence/index creation
    < * Add COMMENT ON for all cluster global objects (users, groups,
    <   databases and tablespaces)
    > * Add NOVICE output level for helpful messages like automatic sequence/index
    >   creation
    > * Add COMMENT ON for all cluster global objects (users, groups, databases
    >   and tablespaces)
    363c360
    <   When enabled, this would allow errors in multi-statement transactions
    >   When enabled, this would allow errors in multi-statement transactions
    417c414
    < 	o Allow COPY to optionally include column headings as the first line
    > 	o Allow COPY to optionally include column headings in the first line
    450c447
    <
    >
    462c459
    < 	o Handle references to temporary tables that are created, destroyed,
    > 	o Handle references to temporary tables that are created, destroyed,
    464c461
    <
    >
    469d465
    < 	o Improve PL/PgSQL exception handling using savepoints
    488c484
    <
    >
    503d498
    <
    518c513
    < 	o Add pg_dumpall custom format dumps.
    > 	o Add pg_dumpall custom format dumps.
    520c515
    < 	  This is probably best done by combining pg_dump and pg_dumpall
    > 	  This is probably best done by combining pg_dump and pg_dumpall
    532d526
    < 	o Improve error handling (?)
    555c549
    <   Adding shared locks requires recording the table/rows numbers in a
    >   Adding shared locks requires recording the table/rows numbers in a
    643c637
    <   Posix_fadvise() can control both sequential/random file caching and
    >   Posix_fadvise() can control both sequential/random file caching and
    703c697
    <   from distributted.net, http://www1.distributed.net/source,
    >   from distributted.net, http://www1.distributed.net/source,
    729c723
    < * Add connection pooling [pool]
    > * Add connection pooling
    755d748
    <
    759c752
    <
    >
    768c761
    <   so an abrupt operating system restart might lose a few seconds of
    >   so an abrupt operating system restart might lose a few seconds of
    785c778
    < * Add utility to compute accurate random_page_cost value
    > * Create utility to compute accurate random_page_cost value
    787,789d779
    < * Allow sorting, temp files, temp tables to use multiple work directories
    <
    <   This allows the I/O load to be spread across multiple disk drives.
    795a786
    >
    808,809c799,800
    <
    < * Use mmap() rather than SYSV shared memory or to write WAL files (?) [mmap]
    >
    > * Use mmap() rather than SYSV shared memory or to write WAL files (?)
    812,813c803,804
    <   portability issues. Anonymous mmap (or mmap to /dev/zero) is required
    <   to prevent I/O overhead.
    >   portability issues. Anonymous mmap (or mmap to /dev/zero) is required
    >   to prevent I/O overhead.
    817,819c808,810
    <   Doing I/O to large tables would consume a lot of address space or
    <   require frequent mapping/unmapping.  Extending the file also causes
    <   mapping problems that might require mapping only individual pages,
    >   Doing I/O to large tables would consume a lot of address space or
    >   require frequent mapping/unmapping.  Extending the file also causes
    >   mapping problems that might require mapping only individual pages,
    821c812
    <   way to _prevent_ I/O to disk from the dirty shared buffers so changes
    >   way to _prevent_ I/O to disk from the dirty shared buffers so changes
    826c817
    <   tuple overhead
    >   per-tuple overhead
    829,831c820,822
    <   This would involve using multiple threads or processes to do optimization,
    <   sorting, or execution of single query.  The major advantage of such a
    <   feature would be to allow multiple CPUs to work together to process a
    >   This would involve using multiple threads or processes to do optimization,
    >   sorting, or execution of single query.  The major advantage of such a
    >   feature would be to allow multiple CPUs to work together to process a
    834c825
    < * Research the use of larger pages sizes
    > * Research the use of larger page sizes
    842a834
    > * Move some /contrib modules out to their own project sites
    845d836
    < * Improve access-permissions check on data directory in Cygwin (Tom)
    847,848c838
    < * Clarify use of 'application' and 'command' tags in SGML docs
    < * Better document ability to build only certain interfaces (Marc)
    > * Improve documentation to build only interfaces (Marc)
    852,853d841
    < * Research interaction of setitimer() and sleep() used by statement_timeout
    < * Rename /scripts directory because they are all C programs now
    856,857d843
    < * Allow binaries to be statically linked so they are more easily relocated
    < * Move some /contrib modules out to their own project sites
    862c848
    < 	o Remove per-backend parameter file and move into shared memory?
    > 	o Remove per-backend parameter file and move into shared memory
    877,878c863,864
    < 	o Update clients to use data types, typmod, schema.table.column names of
    < 	  result sets using new query protocol
    > 	o Update clients to use data types, typmod, schema.table.column names
    > 	  of result sets using new query protocol
    900d885
    < * Kris is Kris Jurka
    910c895
    < * Simon is Simon Riggs
    > * Simon is Simon Riggs <simon@2ndquadrant.com>
    913d897
    < * Teodor is
    6cd67c93
TODO 33.2 KB