summaryrefslogtreecommitdiff
path: root/doc/TODO
AgeCommit message (Collapse)Author
2017-05-21Change documentation references to PG website to use https: not http:Tom Lane
This is more secure, and saves a redirect since we no longer accept plain HTTP connections on the website. References in code comments should probably be updated too, but that doesn't seem to need back-patching, whereas this does. Also, in the 9.2 branch, remove suggestion that you can get the source code via FTP, since that service will be shut down soon. Daniel Gustafsson, with a few additional changes by me Discussion: https://postgr.es/m/9A2C89A7-0BB8-41A8-B288-8B7BD09D7D44@yesql.se
2008-08-21Update URL.Alvaro Herrera
2008-08-20New TODO list URL wiki location listed; contents truncated.Bruce Momjian
2008-08-19Not done:Bruce Momjian
< o -Allow an existing index to be marked as a table's primary key > o Allow an existing index to be marked as a table's primary key
2008-08-19TODO done:Bruce Momjian
! o Allow an existing index to be marked as a table's primary key
2008-08-19Fix some issues that prevent this file to be processed by scripts.Alvaro Herrera
While at it, mark a couple of items completed in 8.4: ! o -Prevent long-lived temporary tables from causing frozen-xid advancement starvation ! * -Improve performance of shared invalidation queue for multiple CPUs Also remove a couple of obsolete assignments.
2008-08-18Add to TODO:Bruce Momjian
> > * Fix all set-returning system functions so they support a wildcard > target list > > SELECT * FROM pg_get_keywords() works but SELECT * FROM > pg_show_all_settings() does not.
2008-08-16Add URL for:Bruce Momjian
* Improve ability to modify views via ALTER TABLE < > http://archives.postgresql.org/pgsql-hackers/2008-08/msg00300.php
2008-08-16Add to TODO:Bruce Momjian
> > * Prevent query cancel packets from being replayed by an attacker, > especially when using SSL > > http://archives.postgresql.org/pgsql-hackers/2008-08/msg00345.php >
2008-08-14Add URL for:Bruce Momjian
* Improve ability to modify views via ALTER TABLE > http://archives.postgresql.org/pgsql-hackers/2008-07/msg01410.php
2008-08-12Remove TODO itemPeter Eisentraut
Allow XML to accept more liberal DOCTYPE specifications Everything works correctly, per today's email to -general.
2008-08-12Add:Bruce Momjian
> * Add 'hostgss' pg_hba.conf option to allow GSS link-level encryption > > http://archives.postgresql.org/pgsql-hackers/2008-07/msg01454.php
2008-07-31Add URL to:Bruce Momjian
* Consider decreasing the I/O caused by updating tuple hint bits > http://archives.postgresql.org/pgsql-patches/2008-07/msg00199.php
2008-07-18Add URL for:Bruce Momjian
* Implement SQL:2003 window functions > http://archives.postgresql.org/pgsql-hackers/2008-07/msg00232.php
2008-07-17Add to TODO:Bruce Momjian
> > * Reduce locking requirements for creating a trigger > > http://archives.postgresql.org/pgsql-hackers/2008-06/msg00635.php >
2008-07-16Add URL for:Bruce Momjian
* Implement SQL:2003 window functions > > http://archives.postgresql.org/pgsql-hackers/2008-06/msg00380.php >
2008-07-16Add to TODO:Bruce Momjian
> > o Add external tool to auto-tune some postgresql.conf parameters > > http://archives.postgresql.org/pgsql-hackers/2008-06/msg00000.php >
2008-07-15Add to TODO:Bruce Momjian
> > o Reduce PITR WAL file size by removing full page writes and > by removing trailing bytes to improve compression
2008-07-15Add TODO:Bruce Momjian
> > * Consider decreasing the I/O caused by updating tuple hint bits > > http://archives.postgresql.org/pgsql-hackers/2008-05/msg00847.php >
2008-07-15Done:Bruce Momjian
> o -Have psql show current values for a sequence
2008-07-14Add to TODO:Bruce Momjian
> * Improve ability to modify views via ALTER TABLE > > http://archives.postgresql.org/pgsql-hackers/2008-05/msg00691.php
2008-07-14Done:Bruce Momjian
< * Add temporal versions of generate_series() > * -Add temporal versions of generate_series()
2008-07-14Add URL for:Bruce Momjian
* Consider allowing control of upper/lower case folding of unquoted identifiers > http://archives.postgresql.org/pgsql-hackers/2008-07/msg00415.php
2008-07-14Done, per Simon:Bruce Momjian
< o Fix server restart problem when the server was shutdown during > o -Fix server restart problem when the server was shutdown during
2008-07-01Add URL for:Bruce Momjian
* Add database and transaction-level triggers
2008-07-01Add to TODO:Bruce Momjian
> * Fix TRUNCATE ... RESTART IDENTITY so its affect on sequences is rolled > back on transaction abort
2008-06-30Add psql TODO:Bruce Momjian
> o Add "auto" expanded mode that outputs in expanded format if > "wrapped" mode can't wrap the output to the screen width > > http://archives.postgresql.org/pgsql-hackers/2008-05/msg00417.php >
2008-06-30Add psql TODO item:Bruce Momjian
> o Add option to wrap column values at whitespace boundaries, > rather than chopping them at a fixed width. > Currently, "wrapped" format chops values into fixed > widths. Perhaps the word wrapping could use the same > algorithm documented in the W3C specification. > http://archives.postgresql.org/pgsql-hackers/2008-05/msg00404.php > http://www.w3.org/TR/CSS21/tables.html#auto-table-layout
2008-06-27Add to TODO:Bruce Momjian
> > * Fix system views like pg_stat_all_tables to use set-returning > functions, rather than views of per-column functions
2008-06-26Add MERGE TODO URL:Bruce Momjian
> http://archives.postgresql.org/pgsql-hackers/2008-04/msg01890.php
2008-06-26Add TODO about security:Bruce Momjian
* Improve server security options http://archives.postgresql.org/pgsql-hackers/2008-04/msg01875.php http://archives.postgresql.org/pgsql-hackers/2008-05/msg00000.php
2008-06-26Add to TODO:Bruce Momjian
> > * Improve LDAP authentication configuration options > > http://archives.postgresql.org/pgsql-hackers/2008-04/msg01745.php
2008-06-24TODO item done:Bruce Momjian
< o Prevent pg_dump/pg_restore from being affected by > o -Prevent pg_dump/pg_restore from being affected by
2008-06-23Add TODO:Bruce Momjian
> > o Allow COPY to report errors sooner > > http://archives.postgresql.org/pgsql-hackers/2008-04/msg01169.php
2008-06-23Add URL for Merge.Bruce Momjian
2008-06-23Add to TODO:Bruce Momjian
> * Allow custom variables to appear in pg_settings()
2008-06-23Add item:Bruce Momjian
* Implement a module capability for loading /contrib-style extensions http://archives.postgresql.org/pgsql-patches/2008-04/msg00164.php
2008-06-23Add TODO:Bruce Momjian
* Consider whether duplicate keys should be sorted by block/offset http://archives.postgresql.org/pgsql-hackers/2008-03/msg00558.php Create new "Sorting" TODO section.
2008-06-19Add URL for:Bruce Momjian
o Allow pg_hba.conf to specify host names along with IP addresses > http://archives.postgresql.org/pgsql-hackers/2008-06/msg00569.php
2008-06-13Modify TODO entry to be a function:Bruce Momjian
> o Add functions to syntax check configuration files > < * Add pg_ctl option to do a syntax check of postgresql.conf
2008-06-12Update item to mention target list problem:Bruce Momjian
< * Allow INSERT/UPDATE ... RETURNING inside a SELECT 'FROM' clause > * Allow INSERT/UPDATE ... RETURNING inside a SELECT 'FROM' clause or > target list > http://archives.postgresql.org/pgsql-hackers/2008-06/msg00124.php
2008-06-11Add:Bruce Momjian
> * Add pg_ctl option to do a syntax check of postgresql.conf
2008-05-31Done: -Remove psql newline patch when we find out why mingw outputs an ↵Andrew Dunstan
extra newline
2008-05-29Add description to:Bruce Momjian
* Add deferred trigger queue file < This item involves dumping large queues into files. > This item involves dumping large queues into files, or doing some > kind of join to process all the triggers, or some bulk operation.
2008-05-29Add URL for:Bruce Momjian
* Add deferred trigger queue file > http://archives.postgresql.org/pgsql-hackers/2008-05/msg00876.php
2008-05-20Done:Bruce Momjian
< o Use LC_TIME for localized weekday/month names, rather than > o -Use LC_TIME for localized weekday/month names, rather than
2008-05-16Done in TODO:Bruce Momjian
> o -Have \l+ show database size, if permissions allow
2008-05-16Done:Bruce Momjian
PL/pgSQL > o -Add CASE capability to language (already in SQL)
2008-05-12Todo done:Bruce Momjian
> * -Improve dead row detection during multi-statement transactions usage
2008-05-10Add URL for:Bruce Momjian
o Allow an existing index to be marked as a table's primary key > > http://archives.postgresql.org/pgsql-hackers/2008-04/msg00500.php