- Notifications
You must be signed in to change notification settings - Fork5
Commit6cd67c9
committed
Cleaups:
< * 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 one60c60< specifications. This is because new databases are created by copying> specifications. This is because new databases are created by copying63c63< directory would create a new database with tables that had incorrect> directory would create a new database with tables that had incorrect72c72<>85c85< By not showing commented-out variables, we discourage people from> By not showing commented-out variables, we discourage people from91c91< * Allow point-in-time recovery to archive partially filled write-ahead> * Allow point-in-time recovery to archive partially filled write-ahead102c102< Currently all schemas are owned by the super-user because they are> Currently all schemas are owned by the super-user because they are128c128< * Allow INET subnet tests with non-constants to be indexed> * Allow INET subnet tests using non-constants to be indexed143,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 time146c146< * Add GUC variable to allow output of interval values in ISO8601 format> * Add a GUC variable to allow output of interval values in ISO8601 format154,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 bits158c158< o Allow nulls in arrays> o Allow NULLs in arrays160,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 expressions218,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 from221c221< (dup) should fail [inheritance]> (dup) should fail246c246< * Fetch heap pages matching index entries in sequential order [performance]> * Fetch heap pages matching index entries in sequential order307c307< functionality in DELETE. It's been agreed that the keyword should> functionality in DELETE. It's been agreed that the keyword should318c318< * Allow PREPARE to automatically determine parameter types based on the SQL> * Allow PREPARE to automatically determine parameter types based on the SQL340,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 transactions417c414< o Allow COPY to optionally include column headings as the first line> o Allow COPY to optionally include column headings in the first line450c447<>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 savepoints488c484<>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_dumpall532d526< 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 a643c637< Posix_fadvise() can control both sequential/random file caching and> Posix_fadvise() can control both sequential/random file caching and703c697< from distributted.net,http://www1.distributed.net/source,> from distributted.net,http://www1.distributed.net/source,729c723< * Add connection pooling [pool]> * Add connection pooling755d748<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 of785c778< * Add utility to compute accurate random_page_cost value> * Create utility to compute accurate random_page_cost value787,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 changes826c817< tuple overhead> per-tuple overhead829,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 a834c825< * Research the use of larger pages sizes> * Research the use of larger page sizes842a834> * Move some /contrib modules out to their own project sites845d836< * 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 now856,857d843< * Allow binaries to be statically linked so they are more easily relocated< * Move some /contrib modules out to their own project sites862c848< o Remove per-backend parameter file and move into shared memory?> o Remove per-backend parameter file and move into shared memory877,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 protocol900d885< * Kris is Kris Jurka910c895< * Simon is Simon Riggs> * Simon is Simon Riggs <simon@2ndquadrant.com>913d897< * Teodor is1 parent4d0f669 commit6cd67c9
1 file changed
+66
-82
lines changed0 commit comments
Comments
(0)