Age | Commit message (Collapse) | Author |
|
Jun Kuwamura
|
|
* Reduce storage space for small NUMERICs
> http://archives.postgresql.org/pgsql-patches/2007-02/msg00505.php
|
|
> * Reduce storage space for small NUMERICs
>
> http://archives.postgresql.org/pgsql-hackers/2007-02/msg01331.php
>
|
|
< o Add more logical syntax CLUSTER table USING index;
> o Add more logical syntax CLUSTER table USING index;
|
|
o Add more logical syntax CLUSTER table USING index;
< o Add more logical syntax CLUSTER table ORDER BY index;
> o Add more logical syntax CLUSTER table USING index;
|
|
* Automatically create rules on views so they are updateable, per SQL99
> http://archives.postgresql.org/pgsql-patches/2006-08/msg00255.php
|
|
< * %Add pg_get_acldef(), pg_get_typedefault(), pg_get_attrdef(),
< pg_get_tabledef(), pg_get_domaindef(), pg_get_functiondef()
<
< These would be for application use, not for use by pg_dump.
<
|
|
>
> * Allow configuration of backend priorities via the operating system
>
> Though backend priorities make priority inversion during lock
> waits possible, research shows that this is not a huge problem.
> http://archives.postgresql.org/pgsql-general/2007-02/msg00493.php
|
|
* Improve dead row detection during multi-statement transactions usage
|
|
> * Increase the number of rows recognized as dead during multi-statement
> transactions
>
> http://archives.postgresql.org/pgsql-patches/2007-03/msg00358.php
>
|
|
>
> * Allow BEFORE INSERT triggers on views
>
> http://archives.postgresql.org/pgsql-general/2007-02/msg01466.php
|
|
> o Add more logical syntax CLUSTER table ORDER BY index;
> support current syntax for backward compatibility
|
|
>
> * Fix cases where invalid byte encodings are accepted by the database,
> but throw an error on SELECT
>
> http://archives.postgresql.org/pgsql-hackers/2007-03/msg00767.php
|
|
CLUSTER:
>
> o %Add VERBOSE option to report tables as they are processed,
> like VACUUM VERBOSE
|
|
<
<
> o During index creation, pre-sort the tuples to improve build speed
>
> http://archives.postgresql.org/pgsql-hackers/2007-03/msg01199.php
>
|
|
< * Add NUMERIC division operator that doesn't round?
<
< Currently NUMERIC _rounds_ the result to the specified precision.
< This means division can return a result that multiplied by the
< divisor is greater than the dividend, e.g. this returns a value > 10:
<
< SELECT (10::numeric(2,0) / 6::numeric(2,0))::numeric(2,0) * 6;
<
< The positive modulus result returned by NUMERICs might be considered
< inaccurate, in one sense.
<
|
|
* Add locale-aware MONEY type, and support multiple currencies
http://archives.postgresql.org/pgsql-hackers/2007-03/msg01181.php
|
|
* Allow accurate statistics to be collected on indexes with more than
one column or expression indexes, perhaps using per-index statistics
> http://archives.postgresql.org/pgsql-hackers/2007-03/msg01131.php
|
|
|
|
< o -Allow commenting of variables in postgresql.conf to restore them
> o Allow commenting of variables in postgresql.conf to restore them
|
|
> o -Allow commenting of variables in postgresql.conf to restore them
< http://archives.postgresql.org/pgsql-hackers/2006-09/msg01481.php
|
|
"If the patch is not BSD-licensed, it will be rejected."
|
|
* Simplify ability to create partitioned tables
> http://archives.postgresql.org/pgsql-hackers/2007-03/msg00375.php
|
|
* Allow sequential scans to take advantage of other concurrent
sequential scans, also called "Synchronised Scanning"
http://archives.postgresql.org/pgsql-hackers/2007-03/msg00415.php
|
|
|
|
> o -Allow psql \pset boolean variables to set to fixed values, rather
|
|
|
|
* Add REPLACE or UPSERT command that does UPDATE, or on failure, INSERT
[merge]
|
|
|
|
|
|
|
|
<li>PostgreSQL is licensed under a BSD license. By posting a patch
to the public PostgreSQL mailling lists, you are giving the PostgreSQL
Global Development Group the non-revokable right to distribute your
patch under the BSD license. If you use code that is available under
some other license that is BSD compatible (eg. public domain), please
note that in your email submission.</li>
|
|
|
|
Robert Treat
|
|
|
|
|
|
|
|
Jun Kuwamura
|
|
|
|
and a Simplified version (China (PRC)).
Backpatch to 8.2.X.
Daojing.Zhou
|
|
|
|
|
|
|
|
|
|
o Allow row and record variables to be set to NULL constants,
and allow NULL tests on such variables
|
|
>
> * Consider decreasing the amount of memory used by PrivateRefCount
>
> http://archives.postgresql.org/pgsql-hackers/2006-11/msg00797.php
> http://archives.postgresql.org/pgsql-hackers/2007-01/msg00752.php
>
|
|
> * Increase locking when DROPing objects so dependent objects cannot
> get dropped while the DROP operation is happening
>
> http://archives.postgresql.org/pgsql-hackers/2007-01/msg00937.php
|
|
o Allow UPDATE/DELETE WHERE CURRENT OF cursor
> http://archives.postgresql.org/pgsql-hackers/2007-01/msg01014.php
|
|
>
> * Add missing operators for geometric data types
>
> Some geometric types do not have the full suite of geometric operators,
> e.g. box @> point
>
|
|
< o Check .pgpass file permissions
>
|