- 09 10月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
< > * Win32 > o Remove per-backend parameter file and move into shared memory? > o Remove configure.in check for link failure when cause is found > o Remove readdir() errno patch when runtime/mingwex/dirent.c rev > 1.4 is released > o Remove psql newline patch when we find out why mingw outputs an > extra newline > o Allow psql to use readline once non-US code pages work with > backslashes
-
- 08 10月, 2004 2 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
* Consider parallel processing a single query 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 single query.
-
- 27 9月, 2004 2 次提交
-
-
由 Bruce Momjian 提交于
> > * Consider automatic caching of queries at various levels: > o Parsed query tree > o Query execute plan > o Query results
-
由 Bruce Momjian 提交于
< Last updated: Sat Sep 25 21:33:44 EDT 2004 > Last updated: Mon Sep 27 10:15:31 EDT 2004 13,19d12 < Remove items before beta? < < Urgent < ====== < < * -Point-in-time data recovery using backup and write-ahead log < * -Create native Win32 port 25d17 < * -Incremental backups 28d19 < * -Allow configuration files to be specified in a different directory 32,34d22 < * -Add the concept of dataspaces/tablespaces (Gavin) < * -Allow logging of only data definition(DDL), or DDL and modification statements < * -Allow log lines to include session-level information, like database and user 54d41 < * -Allow external interfaces to extend the GUC variable set 126d112 < * -Change factorial to return a numeric (Gavin) 141,142d126 < * -Allow pg_dump to dump sequences using NO_MAXVALUE and NO_MINVALUE < * -Prevent whole-row references from leaking memory, e.g. SELECT COUNT(tab.*) 147d130 < * -Make LENGTH() of CHAR() not count trailing spaces 150d132 < * -Support composite types as table columns 198,200d179 < * -Prevent mismatch of frontend/backend encodings from converting bytea < data from being interpreted as encoded strings < * -Fix upper()/lower() to work for multibyte encodings 217d195 < * -Order duplicate index entries on creation by ctid for faster heap lookups 242d219 < * -Be smarter about insertion of already-ordered data into btree index 265,266d241 < * -Allow SELECT * FROM tab WHERE int2col = 4 to use int2col index, int8, < float4, numeric/decimal too 282d256 < * -Allow command blocks to ignore certain types of errors 302,303d275 < * -Allow savepoints / nested transactions (Alvaro) < * -Use nested transactions to prevent syntax errors from aborting a transaction 306,307d277 < * -Prevent COMMENT ON DATABASE from using a database name < * -Add NO WAIT LOCKs 325,326d294 < * -COMMENT ON [ CAST | CONVERSION | OPERATOR CLASS | LARGE OBJECT | LANGUAGE ] < (Christopher) 334d301 < * -Allow more ISOLATION LEVELS to be accepted 347d313 < * -Add GUC setting to make created tables default to WITHOUT OIDS 365,369d330 < o -ALTER TABLE ADD COLUMN does not honor DEFAULT and non-CHECK CONSTRAINT < o -ALTER TABLE ADD COLUMN column DEFAULT should fill existing < rows with DEFAULT value < o -ALTER TABLE ADD COLUMN column SERIAL doesn't create sequence because < of the item above 371,373d331 < o -Allow ALTER TABLE to modify column lengths and change to binary < compatible types < o -Add ALTER DATABASE ... OWNER TO newowner 390,393d347 < o -Add ALTER DOMAIN, AGGREGATE, CONVERSION ... OWNER TO < o -Add ALTER SEQUENCE ... OWNER TO < o -Add ALTER INDEX that works just like ALTER TABLE already does < on an index 404d357 < o -Add ALTER TABLE table SET WITHOUT CLUSTER (Christopher) 411d363 < o -Allow dump/load of CSV format 464d415 < o -Allow Java server-side programming 473d423 < o -Allow PL/pgSQL parameters to be specified by name and type during definition 493,495d442 < * -Allow psql \du to show users, and add \dg for groups < * -Have psql \dn show only visible temp schemas using current_schemas() < * -Have psql '\i ~/<tab><tab>' actually load files it displays from home dir 509,511d455 < o -Allow pg_dump to dump CREATE CONVERSION (Christopher) < o -Make pg_restore continue after errors, so it acts more like pg_dump < scripts 545d488 < o -Implement SET DESCRIPTOR 592,596d534 < * -Have AFTER triggers execute after the appropriate SQL statement in a < function, not at the end of the function < * -Print table names with constraint names in error messages, or make constraint < names unique within a schema < * -Issue NOTICE if foreign key data requires costly test to match primary key 614,615d551 < * -Use dependency information to dump data in proper order < * -Have pg_dump -c clear the database using dependency information 694,695d629 < * -Provide automatic running of vacuum in the background in backend < rather than in /contrib (Matthew) 828d761 < * -Use background process to write dirty shared buffers to disk 843d775 < * -Change representation of whole-tuple parameters to functions 850,852d781 < * -Add checks for fclose() failure (Tom) < * -Change CVS ID to PostgreSQL < * -Exit postmaster if postgresql.conf can not be opened
-
- 26 9月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 21 9月, 2004 1 次提交
-
-
由 Neil Conway 提交于
SQL92 (the former defines a much more ambitious subset of views that need to be updatable).
-
- 14 9月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
< * Point-in-time data recovery using backup and write-ahead log, < * Create native Win32 port, http://momjian.postgresql.org/main/writings/pgsql/project/win32.html > * -Point-in-time data recovery using backup and write-ahead log > * -Create native Win32 port 470c470 < o Fix PL/pgSQL RENAME to work on variables other than OLD/NEW > o Fix PL/pgSQL RENAME to work on variables other than OLD/NEW
-
- 11 9月, 2004 2 次提交
-
-
由 Bruce Momjian 提交于
< * Have AFTER triggers execute after the appropriate SQL statement in a > * -Have AFTER triggers execute after the appropriate SQL statement in a
-
由 Bruce Momjian 提交于
> * Make row-wise comparisons work per SQL spec >
-
- 10 9月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
> * Remove Win32 rename/unlink looping if unnecessary
-
- 02 9月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
> * Consider using hash buckets to do DISTINCT, rather than sorting > > This would be beneficial when there are few distinct values.
-
- 31 8月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
< * Fix oid2name and dbsize for tablespaces
-
- 27 8月, 2004 2 次提交
-
-
由 Bruce Momjian 提交于
< This would require some background daemon to maintain clustering > This might require some background daemon to maintain clustering 397,398c397,398 < paritally filled for easier reorganization. It also might require < creating a merged heap/index data file so an index lookup would > paritally filled for easier reorganization. Another idea would > be to create a merged heap/index data file so an index lookup would
-
由 Bruce Momjian 提交于
< This would require some background daemon to restore clustering > This would require some background daemon to maintain clustering 397c397,399 < paritally filled for easier reorganization. > paritally filled for easier reorganization. It also might require > creating a merged heap/index data file so an index lookup would > automatically access the heap data too.
-
- 26 8月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
> * Merge hardwired timezone names with the TZ database; allow either kind > everywhere a TZ name is currently taken > * Allow customization of the known set of TZ names (generalize the > present australian_timezones hack)
-
- 24 8月, 2004 2 次提交
-
-
由 Bruce Momjian 提交于
< * Implement dirty reads or shared row locks and use them in RI triggers (?) > * Implement dirty reads or shared row locks and use them in RI triggers > > Adding shared locks requires recording the table/rows numbers in a > shared area, and this could potentially be a large amount of data. > One idea is to store the table/row numbers in a separate table and set > a bit on the row indicating looking in this new table is required to > find any shared row locks. >
-
由 Bruce Momjian 提交于
< partial page writes during recovery. > partial page writes during recovery. These pages can also be > eliminated from point-in-time archive files.
-
- 21 8月, 2004 2 次提交
-
-
由 Bruce Momjian 提交于
< o Allow databases, schemas, and indexes to be moved to different < tablespaces > o Allow databases and schemas to be moved to different tablespaces > > One complexity is whether moving a schema should move all existing > schema objects or just define the location for future object creation. > 382c385 < o Add ALTER INDEX that works just like ALTER TABLE already does > o -Add ALTER INDEX that works just like ALTER TABLE already does 384d386 < o Add ALTER INDEX syntax to work like ALTER TABLE indexname
-
由 Bruce Momjian 提交于
< * -Have psql \dn show only visible temp schemas using current_schemas() < * -Have psql '\i ~/<tab><tab>' actually load files it displays from home dir 484a483,484 > * -Have psql \dn show only visible temp schemas using current_schemas() > * -Have psql '\i ~/<tab><tab>' actually load files it displays from home dir 516a517,527 > > * psql tab completion > > o Provide a list of conversions after ALTER CONVERSION? > o Support for ALTER SEQUENCE clauses > o Add RENAME TO to ALTER TRIGGER > o Support for ALTER USER > o Fix ALTER (GROUP|DOMAIN|...) <sth> DROP > o Support for ALTER LANGUAGE <sth> RENAME TO > o Improve support for COPY > o Improve support for ALTER TABLE
-
- 20 8月, 2004 3 次提交
-
-
由 Bruce Momjian 提交于
file variables: < Another option is to allow commented values to return to their < default values. > This has to address environment variables that are then overridden > by config file values. Another option is to allow commented values > to return to their default values.
-
由 Bruce Momjian 提交于
> * Add a function that returns the 'uptime' of the postmaster
-
由 Bruce Momjian 提交于
> Another option is to allow commented values to return to their > default values.
-
- 19 8月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
> o Allow COPY to optionally include column headings as the first line
-
- 18 8月, 2004 4 次提交
-
-
由 Bruce Momjian 提交于
< o Allow pg_dumpall to use non-text output formats
-
由 Bruce Momjian 提交于
> * Move some /contrib modules out to their own project sites
-
由 Bruce Momjian 提交于
< * -Allow pg_dump to dump CREATE CONVERSION (Christopher) < * -Make pg_restore continue after errors, so it acts more like pg_dump scripts 485,486d482 < * Allow pg_dumpall to use non-text output formats < * Have pg_dump use multi-statement transactions for INSERT dumps 493,496d488 < * Allow pg_dump to use multiple -t and -n switches < < This should be done by allowing a '-t schema.table' syntax. < 498a491,512 > > * pg_dump > o Allow pg_dumpall to use non-text output formats > o Have pg_dump use multi-statement transactions for INSERT dumps > o -Allow pg_dump to dump CREATE CONVERSION (Christopher) > o -Make pg_restore continue after errors, so it acts more like pg_dump > scripts > o Allow pg_dump to use multiple -t and -n switches > > This should be done by allowing a '-t schema.table' syntax. > > o Add dumping of comments on composite type columns > o Add dumping of comments on index columns > o Replace crude DELETE FROM method of pg_dumpall for cleaning of > users and groups with separate DROP commands > o Add dumping and restoring of LOB comments > o Stop dumping CASCADE on DROP TYPE commands in clean mode > o Add full object name to the tag field. eg. for operators we need > '=(integer, integer)', instead of just '='. > o Add pg_dumpall custom format dumps. This is probably best done by > combining pg_dump and pg_dumpall into a single binary > o Add CSV output format
-
由 Bruce Momjian 提交于
< * -Allow savepoints / nested transactions [transactions] (Alvaro) > * -Allow savepoints / nested transactions (Alvaro) 348a349,353 > * Add an option to automatically use savepoints for each statement in a > multi-statement transaction. > > When enabled, this would allow errors in multi-statement transactions > to be automatically ignored.
-
- 17 8月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
> o Add ALTER INDEX syntax to work like ALTER TABLE indexname
-
- 16 8月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
> * Set proper permissions on non-system schemas during db creation > > Currently all schemas are owned by the super-user because they are > copied from the template1 database. >
-
- 14 8月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
> > * Allow buffered WAL writes and fsync > > Instead of guaranteeing recovery of all committed transactions, this > would provide improved performance by delaying WAL writes and fsync > so an abrupt operating system restart might lose a few seconds of > committed transactions but still be consistent. We could perhaps > remove the 'fsync' parameter (which results in an an inconsistent > database) in favor of this capability.
-
- 13 8月, 2004 2 次提交
-
-
由 Bruce Momjian 提交于
> o Add ALTER INDEX that works just like ALTER TABLE already does > on an index
-
由 Bruce Momjian 提交于
> * Allow finer control over the caching of prepared query plans > > Currently, queries prepared via the libpq API are planned on first > execute using the supplied parameters --- allow SQL PREPARE to do the > same. Also, allow control over replanning prepared queries either > manually or automatically when statistics for execute parameters > differ dramatically from those used during planning. >
-
- 11 8月, 2004 2 次提交
-
-
由 Bruce Momjian 提交于
< * Allow DELETE to handle table aliases for self-joins > * Allow an alias to be provided for the target table in UPDATE/DELETE 276,279c276,282 < There is no way to create a table alias for the deleted table for use < in the DELETE WHERE clause. The agreed approach is to allow a USING < clause to specify additional tables. UPDATE already has an optional < FROM clause for this purpose. > This is not SQL-spec but many DBMSs allow it. > > * Allow additional tables to be specified in DELETE for joins > > UPDATE already allows this (UPDATE...FROM) but we need similar > functionality in DELETE. It's been agreed that the keyword should > be USING, to avoid anything as confusing as DELETE FROM a FROM b.
-
由 Bruce Momjian 提交于
-
- 10 8月, 2004 3 次提交
-
-
由 Bruce Momjian 提交于
* Add COMMENT ON for all cluster global objects (users, groups, databases and tablespaces)
-
由 Bruce Momjian 提交于
< * Add COMMENT for tablespaces
-
由 Bruce Momjian 提交于
> * Add COMMENT for tablespaces
-
- 07 8月, 2004 2 次提交
-
-
由 Bruce Momjian 提交于
> * Create dump tool for write-ahead logs for use in determining > transaction id for point-in-time recovery
-
由 Bruce Momjian 提交于
> * Un-comment all variables in postgresql.conf 84,85c84,85 < By removing comments we prevent the confusion that commenting a line < returns a modified value to its default, which it does not. > By not showing commented-out variables, we discourage people from > thinking that re-commenting a variable returns it to its default.
-