Age | Commit message (Collapse) | Author |
|
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
|
|
|
|
|
|
< 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
|
|
! o Allow an existing index to be marked as a table's primary key
|
|
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.
|
|
>
> * 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.
|
|
* Improve ability to modify views via ALTER TABLE
<
> http://archives.postgresql.org/pgsql-hackers/2008-08/msg00300.php
|
|
>
> * Prevent query cancel packets from being replayed by an attacker,
> especially when using SSL
>
> http://archives.postgresql.org/pgsql-hackers/2008-08/msg00345.php
>
|
|
* Improve ability to modify views via ALTER TABLE
> http://archives.postgresql.org/pgsql-hackers/2008-07/msg01410.php
|
|
Allow XML to accept more liberal DOCTYPE specifications
Everything works correctly, per today's email to -general.
|
|
> * Add 'hostgss' pg_hba.conf option to allow GSS link-level encryption
>
> http://archives.postgresql.org/pgsql-hackers/2008-07/msg01454.php
|
|
* Consider decreasing the I/O caused by updating tuple hint bits
> http://archives.postgresql.org/pgsql-patches/2008-07/msg00199.php
|
|
* Implement SQL:2003 window functions
> http://archives.postgresql.org/pgsql-hackers/2008-07/msg00232.php
|
|
>
> * Reduce locking requirements for creating a trigger
>
> http://archives.postgresql.org/pgsql-hackers/2008-06/msg00635.php
>
|
|
* Implement SQL:2003 window functions
>
> http://archives.postgresql.org/pgsql-hackers/2008-06/msg00380.php
>
|
|
>
> o Add external tool to auto-tune some postgresql.conf parameters
>
> http://archives.postgresql.org/pgsql-hackers/2008-06/msg00000.php
>
|
|
>
> o Reduce PITR WAL file size by removing full page writes and
> by removing trailing bytes to improve compression
|
|
>
> * Consider decreasing the I/O caused by updating tuple hint bits
>
> http://archives.postgresql.org/pgsql-hackers/2008-05/msg00847.php
>
|
|
> o -Have psql show current values for a sequence
|
|
> * Improve ability to modify views via ALTER TABLE
>
> http://archives.postgresql.org/pgsql-hackers/2008-05/msg00691.php
|
|
< * Add temporal versions of generate_series()
> * -Add temporal versions of generate_series()
|
|
* Consider allowing control of upper/lower case folding of unquoted
identifiers
> http://archives.postgresql.org/pgsql-hackers/2008-07/msg00415.php
|
|
< o Fix server restart problem when the server was shutdown during
> o -Fix server restart problem when the server was shutdown during
|
|
* Add database and transaction-level triggers
|
|
> * Fix TRUNCATE ... RESTART IDENTITY so its affect on sequences is rolled
> back on transaction abort
|
|
> 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
>
|
|
> 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
|
|
>
> * Fix system views like pg_stat_all_tables to use set-returning
> functions, rather than views of per-column functions
|
|
> http://archives.postgresql.org/pgsql-hackers/2008-04/msg01890.php
|
|
* Improve server security options
http://archives.postgresql.org/pgsql-hackers/2008-04/msg01875.php
http://archives.postgresql.org/pgsql-hackers/2008-05/msg00000.php
|
|
>
> * Improve LDAP authentication configuration options
>
> http://archives.postgresql.org/pgsql-hackers/2008-04/msg01745.php
|
|
< o Prevent pg_dump/pg_restore from being affected by
> o -Prevent pg_dump/pg_restore from being affected by
|
|
>
> o Allow COPY to report errors sooner
>
> http://archives.postgresql.org/pgsql-hackers/2008-04/msg01169.php
|
|
|
|
> * Allow custom variables to appear in pg_settings()
|
|
* Implement a module capability for loading /contrib-style extensions
http://archives.postgresql.org/pgsql-patches/2008-04/msg00164.php
|
|
* 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.
|
|
o Allow pg_hba.conf to specify host names along with IP addresses
> http://archives.postgresql.org/pgsql-hackers/2008-06/msg00569.php
|
|
> o Add functions to syntax check configuration files
>
< * Add pg_ctl option to do a syntax check of postgresql.conf
|
|
< * 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
|
|
> * Add pg_ctl option to do a syntax check of postgresql.conf
|
|
extra newline
|
|
* 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.
|
|
* Add deferred trigger queue file
> http://archives.postgresql.org/pgsql-hackers/2008-05/msg00876.php
|
|
< o Use LC_TIME for localized weekday/month names, rather than
> o -Use LC_TIME for localized weekday/month names, rather than
|
|
> o -Have \l+ show database size, if permissions allow
|
|
PL/pgSQL
> o -Add CASE capability to language (already in SQL)
|
|
> * -Improve dead row detection during multi-statement transactions usage
|
|
o Allow an existing index to be marked as a table's primary key
>
> http://archives.postgresql.org/pgsql-hackers/2008-04/msg00500.php
|